View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doug Howell Doug Howell is offline
external usenet poster
 
Posts: 11
Default paste linked cells show "0"

For Excel 2007, this is actually easier....

Excel Options - Advanced - Display Options for this Worksheet
uncheck the "show a zero in cells that have zero value" box