But that could hide the 0's that are returned because the "sending" cell
contains 0.

To the OP, I just use:

=if(a1="","",a1)

(I don't check the length.)

Mr BT wrote:

could you not use a conditional format changing any cell resulting with zero
to a white format?

"T. Valko" wrote in message
...
That's just how it works. An empty cell evalautes as 0 and some functions
do not ignore empty cells. If as you say it worked before it had to have
been because the referenced cell may have contained a formula blank (""),
a space or some other non-visible type of character.

There is no "null" value. The closest you can come is an empty text string
("").

Biff

"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






--

Dave Peterson