| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text in formula bar but not the cell
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text in formula bar but not the cell
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text in formula bar but not the cell
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text in formula bar but not the cell
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text in formula bar but not the cell
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text in formula bar but not the cell
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Matching Text with With Certain Criteria | Excel Worksheet Functions | |||
| reference the result of a formula in a text formatted cell | Excel Discussion (Misc queries) | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
