i am creating a spreadsheet and want the value to be zero when negative is this possible
A atsoc Nov 9, 2005 #1 i am creating a spreadsheet and want the value to be zero when negative is this possible
B Bob Phillips Nov 9, 2005 #2 Use a format of General;"0";General -- HTH RP (remove nothere from the email address if mailing direct)
Use a format of General;"0";General -- HTH RP (remove nothere from the email address if mailing direct)