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!