| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
REVERSING SIGNS OF NUMBERS
Can anyone help me out in revealing a way that all the positive numbers in a
worksheet would convert to negative ones and negative ones to positive ones, without multiplying with -1. Since I further need to calculate upon the same I want to change not only the format but also the true nature. In other words some way other than choosing a custom format. If no other simple way, macros are welcome. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reversing Last Name and First Names | Excel Discussion (Misc queries) | |||
| REVERSING CELLS? | Excel Discussion (Misc queries) | |||
| reversing numbers to create dates | Excel Worksheet Functions | |||
| Reversing First & Last Name | Excel Worksheet Functions | |||
| reversing signs - making postive a negative number | Excel Worksheet Functions | |||
Threaded Mode
