<I did this in another worksheet and it worked fine

I think you're in error. It works the way you found now.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bruce" <oleexpres.at.johnsonclan.net wrote in message ...
| When I enter =Temparary!F2 , I get a zero when referancing a blank cell,
| where I should get a null, why is this happening? I did this in another
| worksheet and it worked fine. I tried several formating options, and it is
| the same. I know I could use n IF(len(Temparary!F2) = 0,"",Temparary!F2),
| but I should not need to. What am I missing?
|
|
|
| Thanks
|
| Bruce
|
|
|