|
|
||||||
|
#1
02-16-09, 08:48 PM
|
|
|
|
|
Why do monetary values show up as the pound sign's?
|
|
|
|
#2
02-16-09, 11:30 PM
|
|
|
|
|
pound signs as in # or the British POund
"John O" wrote: |
|
#3
02-17-09, 03:03 AM
|
|
|
|
|
Check
a) your Regional Settings b) the currency Style BTW: what Excel version and what country are you in? |
|
#4
02-17-09, 01:57 PM
|
|
|
|
|
Yes, this sign, #####
"Pimamedic" wrote: [..] |
|
#5
02-17-09, 02:01 PM
|
|
|
|
|
Excel version is 2003. United States My regional settings are right, and so
is the currency style. "Bernard Liengme" wrote: [..] |
|
#6
02-17-09, 02:02 PM
|
|
|
|
|
Hi John
Most of the time you just need to widen the cells. HTH John "John O" <John O> wrote in message news:3e74 [..] |
|
#7
02-17-09, 02:21 PM
|
|
|
|
|
John
Did you try widening the column ? Regards John "John O" <John O> wrote in message news:3e74 [..] |
|
#8
02-18-09, 11:40 PM
|
|
|
|
|
Wow, how simple was that, thanks for your help!
"John" wrote: [..] |
|
#9
02-18-09, 11:45 PM
|
|
|
|
|
Very easy, I wish I thought of that, feel kinda of foolish, thanks for the
help! "John" wrote: [..] |
|
#10
02-19-09, 12:52 AM
|
|
|
|
|
You're welcome
Don't feel foolish, no one knows everything.Me first!! Regards John "John O" <JohnO> wrote in message news:cc77 [..] |
|
|
| Similar Threads | |
| Merging with Monetary values When merging cannot pick up .00 in currency. Will pick up other numbers. Tried reformatting column, still will not do this. Does anyone have any ideas? thanks, |
|
| How to merge monetary values from Excel to Word? I am trying to merge an excel worksheet to Word, but when I merge the information, such as dollar amounts, i.e. 103,801,186, I lose the commas and I have to go into each... |
|
| locale, format monetary values Hi, Can I use locale to format monetary values? If yes, how? If no, is there something I can use? E.g., I have 10000 and I want to get "$10,000". Thanks, Ray |
|
| Formatting monetary values Okay, I've had enough of trying to figure this out so it's time to ask those who know. What I'm trying to do is quite straightforward but seems to be a nightmare to get... |
|
| How to show monetary values in a DataGrid Hello folks. I have a DataGrid in a Web Form. I´d like to show numeric columns in Money format US$ 10,000.98. However, when I fill the DataGrid from a SqlCommand, it fill in... |
|
|
All times are GMT. The time now is 12:44 PM. | Privacy Policy
|
monetary values