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

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

Roger Govier

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
 
P

Paul Hyett

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
 

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

Retrieving data from a cell in the last row containing data in the worksheet 1
Data in cells not visible 1
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Calling the contents of a random cell 3
Searching a table of data using an array and returning the array's header?!? 5
Referring to columns in the text of a cell 2
Random table of data - need to find every cell that contains specific data 1
Odd VLOOKUP Error 1

Top