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

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

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

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.

On Sun, 18 Sep 2005 18:39:04 -0700, FLKULCHAR
wrote:

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

And if you want to appear blank when the source cell is blank,
instead of putting in H4: =H3, use : =IF(H3="","",H3)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

On Sun, 18 Sep 2005 16:51:11 -0700, 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


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

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________