| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
monetary values
Why do monetary values show up as the pound sign's?
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
monetary values
pound signs as in # or the British POund
"John O" wrote: Why do monetary values show up as the pound sign's? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add a column of monetary numbers | Excel Discussion (Misc queries) | |||
| A function incoprating date and a month/monetary value. | Excel Worksheet Functions | |||
| How to merge monetary values from Excel to Word? | Excel Discussion (Misc queries) | |||
| Matching a name to a specified monetary amount | Excel Worksheet Functions | |||
| Matching a name to a specified monetary amount | Excel Worksheet Functions | |||
Linear Mode
