I'm away from my mac, but doesn't Excel for mac have some kind of "global" prefs, including preferred currency?
So does the computer, so I suppose it could be worth checking both of those. Regards Russell ---------------------------------------------------------- Manor Park Medical Centre www.manorparksurgery.com Tel 01323482301 East Sussex Local Medical Committee (Chair) www.lmcs.info/ Tel 01372389271 ---------------------------------------------------------- Have your say about NHS market reforms Visit www.lookafterournhs.org.uk On 24 March 2010 13:42, nigel proctor <[email protected]> wrote: > Help smuggers. > > I have a spreadsheet open and have formatted cells to show currency as UK > sterling to 2 decimal places. > > When I re-open the doc. a dollar sign has been substituted for the pound > sign. > > Have tried clearing all formatting, re-instating £ sign,saving, but on > close and re-open $ showing....? > > Any clues > > TIA > > Nigel > > > nigel proctor > [email protected] > H T White & Co Ltd > 07792000619 > sent from iPhone > > > > > -- > You received this message because you are subscribed to the Google Groups > "Sussex Mac User Group" group. > To post to this group, send an email to [email protected]. > To unsubscribe from this group, send email to > [email protected] <smug%[email protected]>. > For more options, visit this group at > http://groups.google.com/group/smug?hl=en-GB. > > -- You received this message because you are subscribed to the Google Groups "Sussex Mac User Group" group. To post to this group, send an email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/smug?hl=en-GB.
