LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Text in formula bar but not the cell

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" wrote in message
...
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Matching Text with With Certain Criteria SteveC Excel Worksheet Functions 19 April 4th 06 11:08 AM
reference the result of a formula in a text formatted cell jpwinston Excel Discussion (Misc queries) 1 February 7th 05 05:33 PM
Formula with text and reference to a date cell [email protected] Excel Discussion (Misc queries) 1 January 11th 05 08:15 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 07:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"