Truly Null

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Invoice - 22 Aug 2006 04:10 GMT

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

--
Invoice

Reply to this Message

Biff - 22 Aug 2006 08:00 GMT

> 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

> Hi,
>
[quoted text clipped - 4 lines]
>
> A truly blank cell is what I really need.

Reply to this Message