cell entries
 

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!

cell entries
 

Does making the column wider fix it up?
Ken Johnson

cell entries
 

Does making the column wider fix it up?
Ken Johnson

cell entries
 

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

cell entries
 

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

cell entries
 

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