ExcelBanter - is it possible to make a spreadsheet display '0' when negative

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - is it possible to make a spreadsheet display '0' when negative (https://www.excelbanter.com/excel-worksheet-functions/54461-possible-make-spreadsheet-display-0-when-negative.html)

atsoc

is it possible to make a spreadsheet display '0' when negative

i am creating a spreadsheet and want the value to be zero when negative is
this possible

Bob Phillips

is it possible to make a spreadsheet display '0' when negative

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

All times are GMT +1. The time now is 04:14 PM.