View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.misc
desertres desertres is offline
external usenet poster
 
Posts: 9
Default Why does Excel think blank = zero ?

All instances of a excel worksheet have a style of 'Normal'. That includes a
general format for each cell....well the general format despite what it says
includes a number formatter..see
http://office.microsoft.com/en-ca/ex...488311033.aspx

You would have to create a custom format to show it as blank as the zero
value of the general value format is to show zero.