View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
osubigdog osubigdog is offline
external usenet poster
 
Posts: 1
Default How do i change cell display from #N/A to 0?

when the result of a formula is displayed in a cell, i want it to read "0"
not "#N/A" so that i can use it to link to other cells. how do i accomplish
this?