Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 39
Default Nothing shows in formula bar!

There is nothing showing in the formula bar when going to a cell with data in
it; I can see the data on the sheet, but... The default font is automatic
(black); I have no workbook template (using default); I have not changed
Windows font in anyway; help! Thanks!
--
Marv Lusk

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Nothing shows in formula bar!

Is the sheet protected and the cells are set to unlocked, but hidden?

Or somesuch variation.

ToolsProtection. Is Unprotect Sheet available?


Gord Dibben MS Excel MVP

On Tue, 20 May 2008 10:02:00 -0700, MarvInBoise
wrote:

There is nothing showing in the formula bar when going to a cell with data in
it; I can see the data on the sheet, but... The default font is automatic
(black); I have no workbook template (using default); I have not changed
Windows font in anyway; help! Thanks!


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 39
Default Nothing shows in formula bar!

Thank you for your reply; no, the workbook/worksheet is not protected; I can
see the data just fine in the formula bar on any other computer, just not
this computer; there must be a setting someplace, but I don't know where or
what???
--
Marv Lusk
-----
"Gord Dibben" wrote:

Is the sheet protected and the cells are set to unlocked, but hidden?

Or somesuch variation.

ToolsProtection. Is Unprotect Sheet available?


Gord Dibben MS Excel MVP

On Tue, 20 May 2008 10:02:00 -0700, MarvInBoise
wrote:

There is nothing showing in the formula bar when going to a cell with data in
it; I can see the data on the sheet, but... The default font is automatic
(black); I have no workbook template (using default); I have not changed
Windows font in anyway; help! Thanks!



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Nothing shows in formula bar!

Just to verify..................

You type 1234qwerty in a cell.

You can see 1234qwerty in the cell but nothing is visible in the Formula bar.

Is that correct?

What version of Excel?

I don't use 2007 so don't know if that version has any toggle but definitely not
in earlier versions.


Gord

On Tue, 20 May 2008 11:35:04 -0700, MarvInBoise
wrote:

Thank you for your reply; no, the workbook/worksheet is not protected; I can
see the data just fine in the formula bar on any other computer, just not
this computer; there must be a setting someplace, but I don't know where or
what???


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 39
Default Nothing shows in formula bar!

I really appreciate your quick responses today, and yes, per your question
that would have been the result, i.e., nadda, but I think we figured out that
it has something to do with the additional flat panel display on the
laptop,i.e., Excel looks/acts normally and we can see data in the formula bar
when displayed on the laptopo screen, but when the client drags the Excel
screen to the secondary flat panel display, the data does not show in the
formula bar! It must be something quirky with the graphics adapter! :(

Sorry for the non-Excel issue, but I appreciate your replies.
--
Marv Lusk


"Gord Dibben" wrote:

Just to verify..................

You type 1234qwerty in a cell.

You can see 1234qwerty in the cell but nothing is visible in the Formula bar.

Is that correct?

What version of Excel?

I don't use 2007 so don't know if that version has any toggle but definitely not
in earlier versions.


Gord

On Tue, 20 May 2008 11:35:04 -0700, MarvInBoise
wrote:

Thank you for your reply; no, the workbook/worksheet is not protected; I can
see the data just fine in the formula bar on any other computer, just not
this computer; there must be a setting someplace, but I don't know where or
what???





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 87
Default Nothing shows in formula bar!

Go to the web site for the mfr of the troubled screen and download the
latest drivers for the display.


"MarvInBoise" wrote in message
...
I really appreciate your quick responses today, and yes, per your question
that would have been the result, i.e., nadda, but I think we figured out
that
it has something to do with the additional flat panel display on the
laptop,i.e., Excel looks/acts normally and we can see data in the formula
bar
when displayed on the laptopo screen, but when the client drags the Excel
screen to the secondary flat panel display, the data does not show in the
formula bar! It must be something quirky with the graphics adapter! :(

Sorry for the non-Excel issue, but I appreciate your replies.
--
Marv Lusk


"Gord Dibben" wrote:

Just to verify..................

You type 1234qwerty in a cell.

You can see 1234qwerty in the cell but nothing is visible in the Formula
bar.

Is that correct?

What version of Excel?

I don't use 2007 so don't know if that version has any toggle but
definitely not
in earlier versions.


Gord

On Tue, 20 May 2008 11:35:04 -0700, MarvInBoise
wrote:

Thank you for your reply; no, the workbook/worksheet is not protected; I
can
see the data just fine in the formula bar on any other computer, just
not
this computer; there must be a setting someplace, but I don't know where
or
what???





Reply
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
When I enter a formula, Excel shows the formula not the results Pat Adams Excel Worksheet Functions 5 April 4th 23 11:18 AM
Excel Formula Doesn't Execute (Shows formula-not the calcuation) Keys1970 Excel Discussion (Misc queries) 4 November 15th 06 02:12 PM
cell shows 20. Formula shows 20. why not 540/27 griswold Excel Worksheet Functions 2 August 12th 05 05:56 PM
Cell shows formula and not the result of the formula. stumpy1220 Excel Worksheet Functions 2 January 14th 05 05:11 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM


All times are GMT +1. The time now is 05:47 PM.

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"