Remember Me?

#1
November 14th 05, 01:17 PM
 djjny Posts: n/a
how do you make negative numbers show up as 0 in Excel?

I want to force a formula I have to show up as a zero if the value is less
than zero. I have tried embedding something in the formula to do this, but
it will not work. anyone have any suggestions? Is there a way to format a
field to display zero when the value is less than zero? I am using Excel
2000.

#2
November 14th 05, 01:23 PM
 tiah Posts: n/a
how do you make negative numbers show up as 0 in Excel?

Hello !

go in Format Menu/cells

customize

the type is 0;"0";0

first argument is positive numbers
second is negatives numbers
third is 0 numbers
so the "0" between quotes tells to write 0
the 0 without quotes means the number itself will display

#3
November 14th 05, 01:36 PM
 Duke Carey Posts: n/a
how do you make negative numbers show up as 0 in Excel?

tiah's solution will change the DISPLAY but not the value. In other words,
although the cell might show 0, any formula that referenced the cell would
still use the negative value.

If you need the VALUE to be 0, use

"djjny" wrote:

I want to force a formula I have to show up as a zero if the value is less
than zero. I have tried embedding something in the formula to do this, but
it will not work. anyone have any suggestions? Is there a way to format a
field to display zero when the value is less than zero? I am using Excel
2000.

#4
November 14th 05, 04:39 PM
 tiah Posts: n/a
how do you make negative numbers show up as 0 in Excel?

Hi Duke !

I know this is a display, but i answered to the question !

he ask for a way to "show" 0 and ask for a "format" to "display"

=)

sure i would use your formula

have a nive day !

#5
November 14th 05, 05:29 PM
 Duke Carey Posts: n/a
how do you make negative numbers show up as 0 in Excel?

I offered a different solution only because sometimes the posters don't
realize the consequences of what they are asking for. You have a good day,
too

"tiah" wrote:

Hi Duke !

I know this is a display, but i answered to the question !

he ask for a way to "show" 0 and ask for a "format" to "display"

=)

sure i would use your formula

have a nive day !

#6
March 7th 06, 05:42 PM posted to microsoft.public.excel.worksheet.functions
 kshomebrew Posts: n/a
how do you make negative numbers show up as 0 in Excel?

Hi, this worked great, but now my decimals are missing. Any Help?

"tiah" wrote:

Hello !

go in Format Menu/cells

customize

the type is 0;"0";0

first argument is positive numbers
second is negatives numbers
third is 0 numbers
so the "0" between quotes tells to write 0
the 0 without quotes means the number itself will display

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post johnp Excel Worksheet Functions 2 November 2nd 05 03:24 PM Nivek Charts and Charting in Excel 5 October 27th 05 10:05 PM MEGTOM New Users to Excel 5 October 27th 05 03:06 AM MBAKID007 Excel Discussion (Misc queries) 1 May 24th 05 05:52 PM Dustin Excel Discussion (Misc queries) 0 January 13th 05 01:39 AM

All times are GMT +1. The time now is 02:12 PM.