Excel cell shows and prints as hash marks (#)

P

Phil Mead

I have a cell with text in it, and i can see it when I double-clink on the
cell and edit the text.
However, the regular diaply of the cell shows a string of hash marks, and so
does print preview.
Anyone seen this?
 
J

Jim Thomlinson

It sounds like your cell is formatted as text and you have more than 255
characters in the cell. Change the format to General and all should be well.

Cells formatted as text will show # if the length of the text is between 255
and 1024 characters.
 
L

Luke M

Your column width is too small. Increase the column size. (Or the row size,
and use word wrap)
 

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

Quote Marks Question 2
show text instead of hash marks 1
Excel CSV Files; Creating Of 3
Getting ### (hash) symbols in text cell instead of text 2
Why does some text wrap and fit and other doesn't 3
Cell shows with ######## 9
Generating text surrounded by quotation marks 5
Conditional formatting - check for blank cell 3

Top