Text in formula bar but not the cell

[Rickula2]

I have a strange occurence - my text appears in the formula bar, but does not show in the cell. Any help out there?

[Elkar]

Is the font color set the same as the background color? (ie. White on White)

HTH,
Elkar


"Rickula2" wrote:

>
> I have a strange occurence - my text appears in the formula bar, but
> does not show in the cell. Any help out there?
>
>
> --
> Rickula2
> ------------------------------------------------------------------------
> Rickula2's Profile: http://www.excelforum.com/member.php...o&userid=34027
> View this thread: http://www.excelforum.com/showthread...hreadid=537888
>
>

[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?




Rickula2 wrote:
>
> I have a strange occurence - my text appears in the formula bar, but
> does not show in the cell. Any help out there?
>
> --
> Rickula2
> ------------------------------------------------------------------------
> Rickula2's Profile: http://www.excelforum.com/member.php...o&userid=34027
> View this thread: http://www.excelforum.com/showthread...hreadid=537888

--

Dave Peterson

[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! #$%^$#!

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


Rickula2 wrote:
>
> 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! #$%^$#!
>
> --
> Rickula2
> ------------------------------------------------------------------------
> Rickula2's Profile: http://www.excelforum.com/member.php...o&userid=34027
> View this thread: http://www.excelforum.com/showthread...hreadid=537888

--

Dave Peterson

[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

"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>
>
>
> Rickula2 wrote:
> >
> > I have a strange occurence - my text appears in the formula bar, but
> > does not show in the cell. Any help out there?
> >
> > --
> > Rickula2
> > ------------------------------------------------------------------------
> > Rickula2's Profile:
http://www.excelforum.com/member.php...o&userid=34027
> > View this thread:
http://www.excelforum.com/showthread...hreadid=537888
>
> --
>
> Dave Peterson

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

Art Farrell wrote:
>
> 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
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
> >
> >
> >
> >
> > Rickula2 wrote:
> > >
> > > I have a strange occurence - my text appears in the formula bar, but
> > > does not show in the cell. Any help out there?
> > >
> > > --
> > > Rickula2
> > > ------------------------------------------------------------------------
> > > Rickula2's Profile:
> http://www.excelforum.com/member.php...o&userid=34027
> > > View this thread:
> http://www.excelforum.com/showthread...hreadid=537888
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

[Rodney69]

THis may be a silly answer to your query but I had a similar instance.
After beating my brain for a few hours and trying everything under the sun,
I took time to review the formula and found it said if(data,data,"")
The cell was empty because the formula said to put "" in the cell.

[FDibbins]

Rodney, welcome to the forum

thanks for your contribution to this

However, this thread is 8 years old, I doubt anyone is still following it
(Dont feel bad, this happens all the time )