LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 192
Default one cell in my worksheet appears blank, but answr shows in formula

I have Excel 2003
I have a worksheet that is linked to another worksheet. The sheet is a YTD
of all the data collected for several units.
It's a simple formula where I typed the equal sign in , then clicked on the
cell in the other worksheet so it shows in this worksheet.
One cell out of many appears to be blank, yet when I click on it the actual
answer shows up in the formula bar. I've checked all the formatting and all
appears to be well, the font color is black. I tried re-doing the formula
with the same result.
I deleted the formula from that cell and typed the answer in, with the same
result!
Any idea why it's doing this? Are there gremlins in my worksheet??
Thanks, Susan
 
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
#ref appears when selecting cell in other worksheet v1v8 Excel Worksheet Functions 0 October 23rd 07 05:27 PM
Shows blank worksheet but ok in print preview Big Mac Excel Discussion (Misc queries) 1 November 14th 06 02:36 PM
cell shows 20. Formula shows 20. why not 540/27 griswold Excel Worksheet Functions 2 August 12th 05 05:56 PM
blank data field shows quote in formula, how to delete it? wdanner Excel Discussion (Misc queries) 2 April 4th 05 08:44 PM
Custom format that shows blank cell if another cell is empty Zdenek Moravec Excel Discussion (Misc queries) 1 March 25th 05 11:45 AM


All times are GMT +1. The time now is 08:30 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"