cell entries

[ljmurdock]

I am entering dollar amounts into a spreadsheet that has not been updated in
months. When I delete the old number, then enter the new amount (say,
$13,456.00) into the cell and then click onto the next cell for editing, the
cell that I just entered $13,456.00 instantly converts to #######. What
happened to the numbers and how do I correct this from happening? They are
very simple entries without formulas and I don't understand how to keep the
numbers present in the cell.
--
Thanks!

[Ken Johnson]

Does making the column wider fix it up?
Ken Johnson

[Ken Johnson]

Does making the column wider fix it up?
Ken Johnson

[ljmurdock]

No, there is plenty of room to accomodate the info I am trying to put in. I
just don't understand why Excel changes my dollar figure to a series of
#####'s. Any other thoughts? Lisa
--
Thanks!


"Ken Johnson" wrote:

> Does making the column wider fix it up?
> Ken Johnson
>
>

[protonLeah]

You use the word "delete"; however, "delete" and "clear" are not the same. If you actually deleted a cell, then the replacement needs to be manually formatted as currency.

[Dave Peterson]

You may think that there is enough room. Excel may disagree.

Did you try widening the column? (Even autofitting??)

If you select that cell, then hit alt-F1 and click on the Number tab, what is
the numberformat for that cell?

ljmurdock wrote:
>
> No, there is plenty of room to accomodate the info I am trying to put in. I
> just don't understand why Excel changes my dollar figure to a series of
> #####'s. Any other thoughts? Lisa
> --
> Thanks!
>
> "Ken Johnson" wrote:
>
> > Does making the column wider fix it up?
> > Ken Johnson
> >
> >

--

Dave Peterson