monetary values

[John O]

Why do monetary values show up as the pound sign's?

 

[Pimamedic]

pound signs as in # or the British POund

 

[Bernard Liengme]

Check
a) your Regional Settings
b) the currency Style
BTW: what Excel version and what country are you in?

 

[John O]

Yes, this sign, #####

pound signs as in # or the British POund

 

[John O]

Excel version is 2003. United States My regional settings are right, and so
is the currency style.

 

[John]

Hi John
Most of the time you just need to widen the cells.
HTH
John

 

[John]

John
Did you try widening the column ?
Regards
John

 

[John O]

Wow, how simple was that, thanks for your help!

Hi John
Most of the time you just need to widen the cells.
HTH
John

 

[John O]

Very easy, I wish I thought of that, feel kinda of foolish, thanks for the
help!

 

[John]

You're welcome
Don't feel foolish, no one knows everything.Me first!!
Regards
John