Some text shows in the formula bar but not in the cell.

G

George M.

To anyone who can help me: Occasionally I receive an Excel attachment with an
e-mail were some of the text in some cells appear in the formula bar but not
in the cell itself. Would greatly appreciate assitance . . .
 
D

Doug Kanter

George M. said:
To anyone who can help me: Occasionally I receive an Excel attachment with
an
e-mail were some of the text in some cells appear in the formula bar but
not
in the cell itself. Would greatly appreciate assitance . . .
Click to expand...

Can you provide examples of what's in the formula bar and what you see in
the cell?
 
H

Harald Staff

Just some ideas: White font ? Extremely large or small font ? Leading line
breaks before first visible character ?

HTH. Best wishes Harald
 
D

Duke Carey

Check the font format - it may be white, making it invisible

Check Format>Conditional Formatting to see if something there is preventing
it from showing
 
J

Jamie A Miller

Try to change the format of the cell. The format may be set to a custom
format (;;;) that hides the cell content. Try using the format painter to
copy the format from a cell where you can see the data to the one that you
cannot.
 
D

Dave Peterson

And maybe you just have to widen the column or make the rowheight larger.

If that text is pretty large (greater than about 1000 characters or so), adding
alt-enters to force new lines within the cell can make it so you can see more of
the value in the cell.
 
Top