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