View Single Post
  #1   Report Post  
MelbTim
 
Posts: n/a
Default How do I hide #N/A?


Hi,

I have a large spreadsheet with a lot of formulas. A lot of cells end
up with the value #N/A. Is there a way to hide that value #N/A (ie so
that it looks like there is nothing in the cells)? I hope I'm not
displaying my ignorance here. I have a feeling it's possible and
probably quite simple.

Thanks

Tim


--
MelbTim
------------------------------------------------------------------------
MelbTim's Profile: http://www.excelforum.com/member.php...o&userid=23847
View this thread: http://www.excelforum.com/showthread...hreadid=375130