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!
|