software

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 JohnsonDoes making the column wider fix it up?
Ken JohnsonNo, 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!quot;Ken Johnsonquot; wrote:

gt; Does making the column wider fix it up?
gt; Ken Johnson
gt;
gt;


You use the word quot;deletequot;; however, quot;deletequot; and quot;clearquot; are not the
same. If you actually deleted a cell, then the replacement needs to be
manually formatted as currency.--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: www.excelforum.com/member.php...oamp;userid=32097
View this thread: www.excelforum.com/showthread...hreadid=532510You 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:
gt;
gt; No, there is plenty of room to accomodate the info I am trying to put in. I
gt; just don't understand why Excel changes my dollar figure to a series of
gt; #####'s. Any other thoughts? Lisa
gt; --
gt; Thanks!
gt;
gt; quot;Ken Johnsonquot; wrote:
gt;
gt; gt; Does making the column wider fix it up?
gt; gt; Ken Johnson
gt; gt;
gt; gt;

--

Dave Peterson