FormatCellsNumber tabCustom
In the Type box, enter

#0;"0"

--
Kind regards,

Niek Otten

wrote in message
oups.com...
I need help with a formula:

If the value of a cell is a negative number, display 0, but if the
value in the cell is a positive number, display the value.