View Single Post
  #1   Report Post  
hays4
 
Posts: n/a
Default I want blank cells, but they're all zeros now that I have formatted them


I have formatted my spreadsheet with numbers £ amounts, dates
and allsorts,
but now the subsequent rows all contains zeros,
what function would I use to say - when it's zero, leave the cell
blank
??


--
hays4
------------------------------------------------------------------------
hays4's Profile: http://www.excelforum.com/member.php...o&userid=28069
View this thread: http://www.excelforum.com/showthread...hreadid=475815