View Single Post
  #2   Report Post  
Ashish Mathur
 
Posts: n/a
Default

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