Copying a Blank Cell

F

FLKULCHAR

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
 
A

Ashish Mathur

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
 
F

FLKULCHAR

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.
 
M

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.
 
M

Max

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

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
Click to expand...


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

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Top