insert cell data from one sheet to another
 

When I copy a cell that has no data (it is blank) the destination cell
has a zero, not blank. How can I get it to be blank?

insert cell data from one sheet to another
 

Tools, Options, View, uncheck Zero values

arvinylPE wrote:

When I copy a cell that has no data (it is blank) the destination cell
has a zero, not blank. How can I get it to be blank?

insert cell data from one sheet to another
 

"Bob I" wrote:

Tools, Options, View, uncheck Zero values

arvinylPE wrote:

When I copy a cell that has no data (it is blank) the destination cell
has a zero, not blank. How can I get it to be blank?

Since I forgot to mention that I am using Excel 2007, the"Zero values" option was in a slightly different place, but easy to find. And best of all IT WORKED!

insert cell data from one sheet to another
 

=IF(A1="","",A1)
--
David Biddulph

"arvinylPE" wrote in message
...
When I copy a cell that has no data (it is blank) the destination cell
has a zero, not blank. How can I get it to be blank?

insert cell data from one sheet to another
 

You're welcome, sorry I only have 2003, so best guess. :-)

arvinylPE wrote:


"Bob I" wrote:


Tools, Options, View, uncheck Zero values

arvinylPE wrote:


When I copy a cell that has no data (it is blank) the destination cell
has a zero, not blank. How can I get it to be blank?

Since I forgot to mention that I am using Excel 2007, the"Zero values" option was in a slightly different place, but easy to find. And best of all IT WORKED!