Use a format of General;"0";General

--

HTH

RP
(remove nothere from the email address if mailing direct)


"atsoc" wrote in message
...
i am creating a spreadsheet and want the value to be zero when negative is
this possible