Version 12.0 on G5PPC Mac
Format/ Cells/Number/Currency/
Then Symbol £ (pound sterling)
to 2 decimal places.
Excel applies the format, I save and close, on re-opening the £ is now
$.
So
I cleared all formatting, went through the steps above, same result.
N
On 24 Mar 2010, at 14:21, Keith Scott wrote:
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
.
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.
