insert cell data from one sheet to another

A

arvinylPE

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?
 
A

arvinylPE

Bob I said:
Tools, Options, View, uncheck Zero values


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