cell entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Include a value from one cell within text of another cell. 2
Lock out data entry in a cell 1
"What-if" formula for either a manual entry and automated entry 3
Number/Text combination formula 8
formatting a cell 2
check or uncheck a check box based on a cell value 1
problem with fractions to decimal 1
Summary Worksheet. 1

Back
Top