Truly Null

I

Invoice

Hi,

Is there any way to produce a truly blank cell through a calculation
My formula produces a "" in a numerical column. This is fine for Exce
purposes, but when I import into Access, the "" doesn't get accepte
because it's really text.

A truly blank cell is what I really need
 
B

Biff

Is there any way to produce a truly blank cell through a calculation?

No.

If your formulas otherwise return numerical values:

Select the range of formulas
Hit function key F5
Click Special
Select Formulas
Uncheck everything EXCEPT Text
OK
Goto the menu Edit>Clear>Contents

Now you have a true blank!

Biff
 
Top