I received from the UK an Excel file in which some cells have been formatted
with the currency tool - the cells of course displayed £ symbols.
If I enter a number in a blank cell and clicked my currency tool (I am
Canadian) I got something like £12.56 and not $12.56
If I wanted to get dollars I could use Format | Cells |Currency but I could
not use the currency tool
Workaround: use Format | Styles and discover that the style for the tool was
pounds so I use Modify to make it dollars again
Any help?
Happy New Year
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"tony" wrote in message
...