software

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!!!Widen the column?

--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Jammiequot; gt; wrote in message
...
gt; HI, EXCEL 2003
gt;
gt; The full story is I have a functioning formula in one cell, call it 10A
gt; 3 rows down I want the same forumla resutls to show in 13A,
gt;
gt; When I put in =10A
gt; excel gives me ####
gt;
gt; When I put the mouse over the #### it tells me the correct value.
gt;
gt; When I go in to format cell and on currency reduce the decimal to none,
gt; it
gt; will give me the correct answer or round up to the nearest dollar
gt; depending
gt; on what values I orgininal put in the original formula for 10A.
gt;
gt;
gt;
gt; How can I get this cell, 13A to show me the correct currency with 2
gt; decimal
gt; places?
gt;
gt;
gt; Thanks a buncn!!!
gt;
My lord, so simple of a solution.

I thank you very very much.

This I will remember.

: )

quot;Peo Sjoblomquot; wrote:

gt; Widen the column?
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;Jammiequot; gt; wrote in message
gt; ...
gt; gt; HI, EXCEL 2003
gt; gt;
gt; gt; The full story is I have a functioning formula in one cell, call it 10A
gt; gt; 3 rows down I want the same forumla resutls to show in 13A,
gt; gt;
gt; gt; When I put in =10A
gt; gt; excel gives me ####
gt; gt;
gt; gt; When I put the mouse over the #### it tells me the correct value.
gt; gt;
gt; gt; When I go in to format cell and on currency reduce the decimal to none,
gt; gt; it
gt; gt; will give me the correct answer or round up to the nearest dollar
gt; gt; depending
gt; gt; on what values I orgininal put in the original formula for 10A.
gt; gt;
gt; gt;
gt; gt;
gt; gt; How can I get this cell, 13A to show me the correct currency with 2
gt; gt; decimal
gt; gt; places?
gt; gt;
gt; gt;
gt; gt; Thanks a buncn!!!
gt; gt;
gt;
gt;
gt;