| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I globally change minus numbers to positive ones?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I globally change minus numbers to positive ones?
If the numbers are in a contiguous range:
Type -1 in an empty cell; copy it; select the range of negative numbers and use Edit|Past Special-multiply. Now delete the cell with -1. If the numbers are in a column mixed in with positive: insert a helper column; In top cell of helper column enter =ABS(A1) ... change A1 to fit your situation Copy this down the column; Now use Copy and Paste Special but this time specify Values. Now you have a column of positive numbers and can delete the original column. Any help? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "james" wrote in message ... |
| Reply |
| 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 | |||
| change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
| How do I change minus numbers to + numbers in a col in Excel? | Charts and Charting in Excel | |||
| How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
Hybrid Mode
