| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change series of numbers from pos. to negative & viceversa
I am fairly certain there is a way to do this and I am not finding it.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to change series of numbers from pos. to negative & viceversa
The function is called negation.
The Excel symbol is - The formula is =-A1, and copy down and across as necessary. An alternative is to put -1 in a spare cell, copy, then select your range of cells, and Edit/ Paste Special/ Multiply (or Divide). -- David Biddulph "VH" wrote in message ... I am fairly certain there is a way to do this and I am not finding it. |
| 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 | |||
| 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 to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
Linear Mode
