| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change value in column to negative figures
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change value in column to negative figures
1. Format an empty cell with the same format as the cells you want to
change, 2. type in -1 and press enter 3. Copy the cell 4. Select all cells you want to change and do editpaste special and select multiply -- Regards, Peo Sjoblom "nads" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making all the figures in one column appear as a negative | Excel Discussion (Misc queries) | |||
| How can I change all negative values in a column to = 0? | Excel Worksheet Functions | |||
| How do I change a column of 500 numbers from positive to negative | Excel Discussion (Misc queries) | |||
| How do I change the plus to a negative in a column of numbers? | Excel Worksheet Functions | |||
| How do I change location of figures within a column | Excel Worksheet Functions | |||
Linear Mode
