I want blank cells, but they're all zeros now that I have formatted them

[hays4]

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
??

[neopolitan]

Click on Tools>Options: in the "View" tab in the bottom section titled "Windows Options" uncheck the "Zero Values" check box.