Truly Null
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 EditClearContents
Now you have a true blank!
Biff
"Invoice" wrote in message
...
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 Excel
purposes, but when I import into Access, the "" doesn't get accepted
because it's really text.
A truly blank cell is what I really need.
--
Invoice
|