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!

Does making the column wider fix it up?
Ken Johnson

Does making the column wider fix it up?
Ken Johnson

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

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.


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=532510

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