Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to make negative numbers look like 0
I need to find out how you make negative numbers look like 0's instead of
making them negative for example.... I have a -25 and I need it to look like this "0". This way positive numbers are the only things I have listed on my column. Is this posibble? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200508/1 |
#2
|
|||
|
|||
make another column with a formula:
=IF(A1<0,0,A1) |
#3
|
|||
|
|||
how do you this with %'s ?...I need them to become zeros as well...
Trisha V wrote: I need to find out how you make negative numbers look like 0's instead of making them negative for example.... I have a -25 and I need it to look like this "0". This way positive numbers are the only things I have listed on my column. Is this posibble? -- Message posted via http://www.officekb.com |
#4
|
|||
|
|||
ISNT THERE A WAY TO JUST FORMAT IT?....I ALREADY HAVE THIS COLUMN WITH A
FORMULA. Marvin P. Winterbottom wrote: make another column with a formula: =IF(A1<0,0,A1) -- Message posted via http://www.officekb.com |
#5
|
|||
|
|||
"Trisha V via OfficeKB.com" wrote in message
ISNT THERE A WAY TO JUST FORMAT IT?....I ALREADY HAVE THIS COLUMN WITH A FORMULA. Marvin P. Winterbottom wrote: make another column with a formula: =IF(A1<0,0,A1) No. There isn't. You can't "format" a cell to show a non-negative number. What's the problem with putting the formula in a column next to the original, and then hiding the original column? |
#6
|
|||
|
|||
I GUESS YOU'RE RIGHT..THANKS
Gordon wrote: "Trisha V via OfficeKB.com" wrote in message ISNT THERE A WAY TO JUST FORMAT IT?....I ALREADY HAVE THIS COLUMN WITH A FORMULA. make another column with a formula: =IF(A1<0,0,A1) No. There isn't. You can't "format" a cell to show a non-negative number. What's the problem with putting the formula in a column next to the original, and then hiding the original column? -- Message posted via http://www.officekb.com |
#7
|
|||
|
|||
ACTUALLY THIS IS NOT THAT EASY TO DO WHEN YOU'RE WORKING WITH A PIVOT TABLE
Gordon wrote: "Trisha V via OfficeKB.com" wrote in message ISNT THERE A WAY TO JUST FORMAT IT?....I ALREADY HAVE THIS COLUMN WITH A FORMULA. make another column with a formula: =IF(A1<0,0,A1) No. There isn't. You can't "format" a cell to show a non-negative number. What's the problem with putting the formula in a column next to the original, and then hiding the original column? -- Message posted via http://www.officekb.com |
#8
|
|||
|
|||
NEVER MIND.... I DID IT....THANKS
Trisha V wrote: ACTUALLY THIS IS NOT THAT EASY TO DO WHEN YOU'RE WORKING WITH A PIVOT TABLE "Trisha V via OfficeKB.com" wrote in message [quoted text clipped - 8 lines] What's the problem with putting the formula in a column next to the original, and then hiding the original column? -- Message posted via http://www.officekb.com |
#9
|
|||
|
|||
"Trisha V via OfficeKB.com" wrote in message
NEVER MIND.... I DID IT....THANKS Well tell us how, so in future we know! |
#10
|
|||
|
|||
IM ACTUALLY STILL HAVING A PROBLEM WITH IT...IM GETTING AN ERROR MESSAGE
#DIV/0! THIS I DONT KNOW HOW TO FIX...MAYBE IF I CAND SEND WHAT IM WORKING ON TO SOMEONE BECAUSE I CANT EVEN EXPLAIN WHATS WRONG....ITS A BIGGGGG FILE. Gordon wrote: "Trisha V via OfficeKB.com" wrote in message NEVER MIND.... I DID IT....THANKS Well tell us how, so in future we know! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200508/1 |
#11
|
|||
|
|||
Trisha,
A custom format of 0;"0";0 will display negative numbers as zero, though it won't change the underlying value. HTH, Bernie MS Excel MVP "Trisha V via OfficeKB.com" wrote in message ... ISNT THERE A WAY TO JUST FORMAT IT?....I ALREADY HAVE THIS COLUMN WITH A FORMULA. Marvin P. Winterbottom wrote: make another column with a formula: =IF(A1<0,0,A1) -- Message posted via http://www.officekb.com |
#12
|
|||
|
|||
thanks
Bernie Deitrick wrote: Trisha, A custom format of 0;"0";0 will display negative numbers as zero, though it won't change the underlying value. HTH, Bernie MS Excel MVP "Trisha V via OfficeKB.com" wrote in message ... ISNT THERE A WAY TO JUST FORMAT IT?....I ALREADY HAVE THIS COLUMN WITH A FORMULA. make another column with a formula: =IF(A1<0,0,A1) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200508/1 |
#13
|
|||
|
|||
Trisha V via OfficeKB.com Wrote: ISNT THERE A WAY TO JUST FORMAT IT?....I ALREADY HAVE THIS COLUMN WITH A FORMULA. Marvin P. Winterbottom wrote: make another column with a formula: =IF(A1<0,0,A1) -- Message posted via http://www.officekb.com use conditional format if cell value < than 0 then format the text same color as background - so it seems to dissappear -- ufo_pilot ------------------------------------------------------------------------ ufo_pilot's Profile: http://www.excelforum.com/member.php...o&userid=25972 View this thread: http://www.excelforum.com/showthread...hreadid=392504 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum and Skip Negative Numbers | Excel Worksheet Functions | |||
FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN | Excel Discussion (Misc queries) | |||
need to make a cell with numbers ascend when printed in multiple? | Excel Worksheet Functions | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions |