Random replacement of data in a cell with a #####

  • Thread starter Thread starter hondo
  • Start date Start date
H

hondo

I've opened up some saved spread sheets and a few random cells display #####
instead of the data that was entered. When placing the cursor over the cell
the correct data shows in a balloon. Deleting the ###### and attempting to
replace the data doesn't work, the ###### just reappears. How can I fix
this????
 
HI

Just widen the columns where the #####'s appear

--
Regards
Roger Govier

hondo said:
I've opened up some saved spread sheets and a few random cells display
#####
instead of the data that was entered. When placing the cursor over the
cell
the correct data shows in a balloon. Deleting the ###### and attempting to
replace the data doesn't work, the ###### just reappears. How can I fix
this????

__________ Information from ESET Smart Security, version of virus
signature database 4826 (20100202) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 4826 (20100202) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
I've opened up some saved spread sheets and a few random cells display #####
instead of the data that was entered. When placing the cursor over the cell
the correct data shows in a balloon. Deleting the ###### and attempting to
replace the data doesn't work, the ###### just reappears. How can I fix
this????
Click to expand...

This just means the content is too long to be fully displayed - you'll
need to widen the column it's in.

Select the column, then select : Format>Column>Autofit Selection
 
Back
Top