| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need formula to change cells from negative numbers to a zero.
I am creating a work sheet with several different formulas in it (all
accounting formulas) and after entering numbers into other cells it changes some of the other cells to have a negative balance. OK, so I need to know if there is a formula that I can enter into certain cells that will change any negative balance no matter what it may be from showing the negative balance to showing a zero (0) instead? Does anyone know how to do this or have any suggestions on how I could find out? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change positive numbers to negative numbers without re-ente | Excel Worksheet Functions | |||
| Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
| CHANGE A ROW OF POSTIVE NUMBERS TO NEGATIVE NUMBERS | Excel Discussion (Misc queries) | |||
| change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
| How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
Threaded Mode
