View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Why do these symbols #### appear after correcting data in a cell?

A number of possibilities.
The most likely is that the column width is insufficient for displaying your
data. You can either widen the column (for example by autofit), or reduce
the font size.
Another posibility is that you are trying to display a negative number in
date or time format. In that case, switch to 1904 date format but be aware
of the dangers.
--
David Biddulph

"Jim" wrote in message
...
After correcting or updating informartion entered into a cell, then going
to
next cell, all of these appear in the previous cell instead of the
information entered & saved?