Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Currency format not working
After exporting numbers from Quickbooks into Excel (2003), I tried changing
them to a currency format, but the numbers refuse to change. Original number 3000 What I want $3,000 I also tried General, Text, et all. Any idea what is going on here? How do I get it to conform? Thanks! Amy Amy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Currency format not working
It's possible (though unlikely) that your definition of the currency style
has changed. You can rul that out by typing a number in a blank cell and applying that style. If it's as you expect, then the style definition is okay. The likely issue is that you've somehow got text instead of numbers. Just changing the format won't coerce a string into a numeric value. You can force the conversion, however. Enter a 0 in some blank cell and copy it (ctrl+c). Then highlight the numbers you've gotten out of QB and Edit Paste Special, select Values and Add, then click OK. That will force the strings of numbers to be converted into numeric values, to which you can then apply the currency style. "Amy" wrote: After exporting numbers from Quickbooks into Excel (2003), I tried changing them to a currency format, but the numbers refuse to change. Original number 3000 What I want $3,000 I also tried General, Text, et all. Any idea what is going on here? How do I get it to conform? Thanks! Amy Amy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Currency format not working
That worked beautifully. Thanks bpeltzer!
"bpeltzer" wrote: It's possible (though unlikely) that your definition of the currency style has changed. You can rul that out by typing a number in a blank cell and applying that style. If it's as you expect, then the style definition is okay. The likely issue is that you've somehow got text instead of numbers. Just changing the format won't coerce a string into a numeric value. You can force the conversion, however. Enter a 0 in some blank cell and copy it (ctrl+c). Then highlight the numbers you've gotten out of QB and Edit Paste Special, select Values and Add, then click OK. That will force the strings of numbers to be converted into numeric values, to which you can then apply the currency style. "Amy" wrote: After exporting numbers from Quickbooks into Excel (2003), I tried changing them to a currency format, but the numbers refuse to change. Original number 3000 What I want $3,000 I also tried General, Text, et all. Any idea what is going on here? How do I get it to conform? Thanks! Amy Amy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency format depending on drop-down box | Excel Discussion (Misc queries) | |||
Currency format within an equation... | Excel Worksheet Functions | |||
Conditional Format Not Working | Excel Discussion (Misc queries) | |||
when I mail merge my data (currency) format is lost? Help | Excel Discussion (Misc queries) | |||
convert a numerical currency into word format | Excel Worksheet Functions |