| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
| 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 | |||
Hybrid Mode
