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!!!

Widen the column?

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Jammie" <[email protected]> wrote in message
news:[email protected]...
> 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!!!
>

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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!!!
> >
>
>
>