| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to change Negative numbers to positive
Hi
I have a column of data that shows all numbers as negativie numbers. Is there a formula I can write that can be dragged down the column to change the negative numbers into positive numbers? For example, if a cell contains -500.00 I would like to convert that number to 500.00 Regards Malcolm Davidson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change numbers from positive to negative. | Excel Worksheet Functions | |||
| Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
| Change series of numbers from positive to negative | Excel Discussion (Misc queries) | |||
| change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
| How do I change a column of 500 numbers from positive to negative | Excel Discussion (Misc queries) | |||
Threaded Mode
