Posted to microsoft.public.excel.worksheet.functions

TommyD[_2_] TommyD[_2_] is offline

external usenet poster

Posts: 3

Reference shows zero

Hi,

I have a cell reference in cell B1 (=A1).

If A1 is empty B1 shows "0". Why isn't B1 empty if A1 is?

Both cells have format General.

/Tommy

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Cell Reference Shows "0"	Dale[_3_]	Excel Discussion (Misc queries)	1	January 22nd 08 06:36 AM
Cells shows #NA	tankerman	Excel Discussion (Misc queries)	1	December 24th 06 12:56 PM
format a cell with a formula so an empty reference cell shows blan	M2	Excel Discussion (Misc queries)	3	November 7th 06 10:42 PM
Cell only shows link in text, not contents of reference cell	Jay Mac	New Users to Excel	4	August 23rd 05 08:36 PM
cell shows 20. Formula shows 20. why not 540/27	griswold	Excel Worksheet Functions	2	August 12th 05 05:56 PM

All times are GMT +1. The time now is 01:56 PM.

About Us

"It's about Microsoft Excel"