Multiple #### signs taking over

[Guest]

Hello

Has anyone encountered a situation wherein after entering a specific number of characters into a single Excel cell, everything turns into ### signs? I think there is some corruption in the worksheet itself, but hate to have to start all over with a new one. Any suggestions on overcoming this problem

Thanks

 

[DDM]

Ken, assuming the cell is formatted for numbers, the ######s simply mean the
column isn't wide enough. Just widen the column and see if that doesn't fix
it.
--
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

Hello,

Has anyone encountered a situation wherein after entering a specific

number of characters into a single Excel cell, everything turns into ###
signs? I think there is some corruption in the worksheet itself, but hate
to have to start all over with a new one. Any suggestions on overcoming
this problem?

 

[Dave Peterson]

And if the cell is formatted as text and you have long strings in them, try
formatting them as General.