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.

"Ashish Mathur" wrote:

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

"FLKULCHAR" wrote:

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