View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default 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!!!