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!