| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I change a range of cells with - totals to positive ?
Is there a Function/option to change a range of sells from negative to
positive without making the font red ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I change a range of cells with - totals to positive ?
You can use a helper cell (or a column of helper cells) which would contain
formulas like: =abs(a1) This returns the absolute value of a number. It'll always be non-negative (greater than or equal to 0). Fox wrote: Is there a Function/option to change a range of sells from negative to positive without making the font red ? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I change a range of cells with - totals to positive ?
Hi,
I'm not sure what this thing about making the font red has to do with anything? If you want to change negative numbers to positive number then: 1. Enter -1 in a blank cell 2. Copy that cell 3. Select all the negative cells and choose Edit, Paste Special, Multiply. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Fox" wrote: Is there a Function/option to change a range of sells from negative to positive without making the font red ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cause formulae totals to reflect negative and positive amount inpu | Excel Discussion (Misc queries) | |||
| Format cells to change a number from a positive to negative | Excel Worksheet Functions | |||
| change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
| formula to copy last positive number in range of cells | Excel Worksheet Functions | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
Linear Mode
