Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 =MAX(your current formula,0) "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
|
|||
|
|||
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
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I type Excel numbers to show as a barcode? | Excel Worksheet Functions | |||
Can I make Excel sort and graph a list of numbers? | Charts and Charting in Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel text to numbers | Excel Discussion (Misc queries) | |||
how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) |