Hello
Gates Is Antichrist
Board Master
I have excel 2002 excel running on o/s win98.
Test1
I tested you query with the results on exising worksheets that have data and upon entering =false in cell A1 with B1 set = to A1.... the results 0 and 0.
Test2
I tested same into a new worksheet of the same workbook, I was obtained the results FALSE and FALSE.
Test3
I tested same into a new fresh new worksheet of fresh wookbook and I received the results FALSE and FALSE.
Test4
I opened a new workbook, entered some text, numbers, and dates --saved the file, reopened it and was able to get the FALSE FALSE results
I tried various option toggles, tried various cell format options...and could not change the results form those noted above.
I had an initial thought that maybe it had to the version that the file was saved under. (as I have various saved file versions) but no...no difference.
Hope this helps.
Want me to try some other checks?
pll
This message was edited by plettieri on 2002-10-24 20:53