View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default 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