Nigel
Could you say which version of Excel you are using?
And have you created a "custom" format for the currency?
There must be some reason for the problem, but from your description it
does seem weird.
What do you mean by "re-instating" the £ sign?
Altering or creating a custom number format?
Using Format/Number/Currency on the relevant cells?
Or anything else?
If you tell me what you have done, I have various versions of Excel
available to double check it for you.
Keith
=========================================================
nigel proctor 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].
For more options, visit this group at
http://groups.google.com/group/smug?hl=en-GB.
