R
Rickula2
I have a strange occurence - my text appears in the formula bar, but
does not show in the cell. Any help out there?
does not show in the cell. Any help out there?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Elkar
Is the font color set the same as the background color? (ie. White on White)
HTH,
Elkar
HTH,
Elkar
D
Dave Peterson
Does formatting the cell as General help?
Do you have format|conditional formatting applied to that cell?
Do you have any normal formatting (like white font on white fill) applied to
that cell?
Do you have format|conditional formatting applied to that cell?
Do you have any normal formatting (like white font on white fill) applied to
that cell?
R
Rickula2
but the first thing I checked was to see if I accidently made the fill
and font the same color. I hadn't. I can't figure out what
conditional formatting I might have that would cause the contents of
the cell not to be visible. Has to be something on my machine... if I
view it on someone else's cpu, it shows! #$%^$#!
and font the same color. I hadn't. I can't figure out what
conditional formatting I might have that would cause the contents of
the cell not to be visible. Has to be something on my machine... if I
view it on someone else's cpu, it shows! #$%^$#!
D
Dave Peterson
I don't have a good guess at why a different pc can open the same file and see
the value.
Any chance you could just select that cell
edit|clear|All
And retype the formula/value.
the value.
Any chance you could just select that cell
edit|clear|All
And retype the formula/value.
A
Art Farrell
Hi,
As Dave said setting the format to General may take care of it. Another way
to get the condition you have is to put a Custom format of- ;;; -in the
cell. This will show a blank cell and text will show in the formula bar.
CHORDially,
Art Farrell
As Dave said setting the format to General may take care of it. Another way
to get the condition you have is to put a Custom format of- ;;; -in the
cell. This will show a blank cell and text will show in the formula bar.
CHORDially,
Art Farrell
D
Dave Peterson
But that wouldn't explain why another user could see the value when they opened
the workbook on their pc.
I'm hoping that Rickula2 finds the solution and posts back.
the workbook on their pc.
I'm hoping that Rickula2 finds the solution and posts back.
Art said:Hi,
As Dave said setting the format to General may take care of it. Another way
to get the condition you have is to put a Custom format of- ;;; -in the
cell. This will show a blank cell and text will show in the formula bar.
CHORDially,
Art Farrell