Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can i change a number formatted as positive to negative in Excel
I'd like to change from positive to negative numbers
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
can i change a number formatted as positive to negative in Excel
In an un-used cell enter -1
copy that cell select the cells you wish to invert pull-down: Edit PasteSpecial... check the multiply box "byron miranda" wrote: I'd like to change from positive to negative numbers |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
can i change a number formatted as positive to negative in Excel
Depending on what exactly you want there are several things you can do.
If you want to have it on a differen cell you can use a formula in a separate column, like: =-A1 If you want to replace on the cell, you can enter "-1" in a separate cell, copy that cell, select the cell(s) you want to change, and go to Edit - Paste Especial - Multiply. You can even make possitive numbers to look as negative, while still being possitive, applying a custom format like -#;# I wouldn't recommend doing this. Hope this helps, Miguel. "byron miranda" wrote: I'd like to change from positive to negative numbers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
negative number to positive number | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Excel should allow me to change default number formats | Excel Discussion (Misc queries) | |||
change cell from negative to positive | Excel Discussion (Misc queries) | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) |