How do I change the display of a negative number to just read 0?

On Mon, 18 Apr 2005 02:24:01 -0700, [email protected]
<[email protected]@discussions.microsoft.com> wrote:


One way:

Format/Cells/Number/Custom Type: 0;\0;0


--ron

Hi!

Select the cells you want, to modicy and click on Format, Cells

Click on the Number tab and click "Custom"

In the field type the following

#,##0.00;"0"

And click OK

You can specify up to four components for a number format:

How the contents are displayed if they're positive
How the contents are displayed if they're negative
How the contents are displayed if they equate to zero
How the contents are displayed if they're text

Each parameter is seperated by a semicolon.

In my example, I just specify the positive and negative formats
Positive is comma seperation for millions, thousands etc with 2 dec places
Negative is a label "0"

Hope this helps

Pete





What the number looks like if it's negative




"[email protected]" wrote:

>

Personally, and this isn't necessarily the best answer, I would use an IF statement to get the desired result. It helps me personally maintain an overview:

=IF(your_formula<0,0,your_formula)