Copying a Blank Cell

[Guest]

Why when I copy from a totally blank cell to another, instead of a blank
cell, I get a 0 (zero)???

I wish the cell to be blank when I press Ctrl "C" and "Ctrl" V.

How to do it?

thanks,

FLKulchar

 

[Guest]

Hi,

Strangely when i do so the resukt is blank and not a zero. However, you may
try the following:

If(countblank(cell)=1,"",cell)

This will return a blank cell if the cell from where you are copying is blank.

Regards

 

[Guest]

I actually STATED THE PROBLEM erroneously;

your RSVP works perfectlt, BUT how come, eg, when in cell H4, I write "=H3",
and cell H3 is blank, it returns a 0 (zero)?? Please explain.

 

[Myrna Larson]

That's just the way Excel works in this situation. H3 is treated as a numeric
value, and a blank cell is equal to 0.

 

[Max]

And if you want to appear blank when the source cell is blank,
instead of putting in H4: =H3, use : =IF(H3="","",H3)

 

[Richard Buttrey]

Why when I copy from a totally blank cell to another, instead of a blank
cell, I get a 0 (zero)???

I wish the cell to be blank when I press Ctrl "C" and "Ctrl" V.

How to do it?

thanks,

FLKulchar

How about Tools Options and unselecting the "zero values" option?

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________