G Guest Oct 10, 2007 #1 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?
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?
G Guest Oct 10, 2007 #3 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...
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...
