Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel showing a row of ##### in stead of dollars, but when
HI, EXCEL 2003
The full story is I have a functioning formula in one cell, call it 10A 3 rows down I want the same forumla resutls to show in 13A, When I put in =10A excel gives me #### When I put the mouse over the #### it tells me the correct value. When I go in to format cell and on currency reduce the decimal to none, it will give me the correct answer or round up to the nearest dollar depending on what values I orgininal put in the original formula for 10A. How can I get this cell, 13A to show me the correct currency with 2 decimal places? Thanks a buncn!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel showing a row of ##### in stead of dollars, but when
Widen the column?
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "Jammie" wrote in message ... HI, EXCEL 2003 The full story is I have a functioning formula in one cell, call it 10A 3 rows down I want the same forumla resutls to show in 13A, When I put in =10A excel gives me #### When I put the mouse over the #### it tells me the correct value. When I go in to format cell and on currency reduce the decimal to none, it will give me the correct answer or round up to the nearest dollar depending on what values I orgininal put in the original formula for 10A. How can I get this cell, 13A to show me the correct currency with 2 decimal places? Thanks a buncn!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel showing a row of ##### in stead of dollars, but when
My lord, so simple of a solution.
I thank you very very much. This I will remember. : ) "Peo Sjoblom" wrote: Widen the column? -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Jammie" wrote in message ... HI, EXCEL 2003 The full story is I have a functioning formula in one cell, call it 10A 3 rows down I want the same forumla resutls to show in 13A, When I put in =10A excel gives me #### When I put the mouse over the #### it tells me the correct value. When I go in to format cell and on currency reduce the decimal to none, it will give me the correct answer or round up to the nearest dollar depending on what values I orgininal put in the original formula for 10A. How can I get this cell, 13A to show me the correct currency with 2 decimal places? Thanks a buncn!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
I have text in an Excel Cell that isn't showing all of it? | Excel Discussion (Misc queries) | |||
Add-in correctly deleted in Excel but still showing up in MSIE ?????????? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
In Excel, how do you get it to not automatically round my dollars. | Excel Worksheet Functions |