monetary values
 

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

monetary values
 

pound signs as in # or the British POund

"John O" wrote:

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

monetary values
 

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?

monetary values
 

Yes, this sign, #####

"Pimamedic" wrote:

pound signs as in # or the British POund

"John O" wrote:

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

monetary values
 

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

"Bernard Liengme" wrote:

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?

monetary values
 

Hi John
Most of the time you just need to widen the cells.
HTH
John
"John O" <John wrote in message
...
Yes, this sign, #####

"Pimamedic" wrote:

pound signs as in # or the British POund

"John O" wrote:

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

monetary values
 

John
Did you try widening the column ?
Regards
John
"John O" <John wrote in message
...
Yes, this sign, #####

"Pimamedic" wrote:

pound signs as in # or the British POund

"John O" wrote:

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

monetary values
 

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

"John" wrote:

Hi John
Most of the time you just need to widen the cells.
HTH
John
"John O" <John wrote in message
...
Yes, this sign, #####

"Pimamedic" wrote:

pound signs as in # or the British POund

"John O" wrote:

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

monetary values
 

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

"John" wrote:

John
Did you try widening the column ?
Regards
John
"John O" <John wrote in message
...
Yes, this sign, #####

"Pimamedic" wrote:

pound signs as in # or the British POund

"John O" wrote:

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

monetary values
 

You're welcome
Don't feel foolish, no one knows everything.Me first!!
Regards
John
"John O" wrote in message
...
Very easy, I wish I thought of that, feel kinda of foolish, thanks for the
help!

"John" wrote:

John
Did you try widening the column ?
Regards
John
"John O" <John wrote in message
...
Yes, this sign, #####

"Pimamedic" wrote:

pound signs as in # or the British POund

"John O" wrote:

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