Why is my cell text not appearing?

M

Mister PM

My text cell shows "####" and I suspect I've exceeded the 255 character
limit. Is there another cause? If so, is there a way to remedy it?
 
B

bj

Text cells typically do not show the "####".
somew more info please as in what version of Excel are you running and what
would you expect it to show.
 
D

Dave Peterson

If it's text, try changing the format of that cell to General.

Long text (255 characters to 1024 characters) in cells formatted as Text will
show as ####'s.
 
M

Mister PM

Excel 2003 SP 1 as part of Office Professional

bj said:
Text cells typically do not show the "####".
somew more info please as in what version of Excel are you running and what
would you expect it to show.
Click to expand...
 
M

Mister PM

That fixed it! Thanks for the tip.

Dave Peterson said:
If it's text, try changing the format of that cell to General.

Long text (255 characters to 1024 characters) in cells formatted as Text will
show as ####'s.
Click to expand...
 
Top