| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel change a group of positive numbers to negitive numbers
I believe you can easily change a group of positive numbers to negitive
numbers, but I can't remember how. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel change a group of positive numbers to negitive numbers
Hi, Insert a column and enter in B1 =A1*-1 copy formula down "Clare Jones" wrote: I believe you can easily change a group of positive numbers to negitive numbers, but I can't remember how. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel change a group of positive numbers to negitive numbers
Enter -1 into an empty cell and then copy that cell.
Select your range of numbers and then do a paste special and select multiply. "Clare Jones" wrote: I believe you can easily change a group of positive numbers to negitive numbers, but I can't remember how. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel change a group of positive numbers to negitive numbers
Formula way:
=-A1 or =-ABS(A1) if you want to keep negative values as negative. or other way is to input -1 into a cell somewhere, copy it, then do a paste special, multiply. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Clare Jones" wrote: I believe you can easily change a group of positive numbers to negitive numbers, but I can't remember how. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a column of positive numbers to negitive numbers | Excel Worksheet Functions | |||
| Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
| Coloring cells based on positive or negitive numbers | Excel Discussion (Misc queries) | |||
| change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
| How do I change numbers from positive to negitive | Excel Worksheet Functions | |||
Linear Mode
