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 . . .

"George M." <George wrote in message
...
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 . . .

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

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

HTH. Best wishes Harald

"George M." <George skrev i melding
...
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 . . .

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.

"Harald Staff" wrote:

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

HTH. Best wishes Harald

"George M." <George skrev i melding
...
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 . . .

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

Check FormatConditional Formatting to see if something there is preventing
it from showing

"George M." wrote:

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 . . .

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.

George M. wrote:

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 . . .

--

Dave Peterson