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

<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
|
|
|

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

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

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