Check
a) your Regional Settings
b) the currency Style
BTW: what Excel version and what country are you in?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"John O" <John wrote in message
...
Why do monetary values show up as the pound sign's?