Hi,
That will work if cell A1 has a formula in it.
If negative numbers are just typed in, you can use conditional formatting.
Highlight the range of cells you want to format.
Go to Format Conditional Formatting...
Enter cell value is less than 0.
Click the Format... button and select Color: and then click the white icon.
HTH

--
Ken Hudson


"Marcelo" wrote:

=if(A1<0,"",A1)

HTH
Regards from Brazil
Marcelo

"cfuller" escreveu:

how do I hide the display of negative numbers?