Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change series of numbers from positive to negative
I have a series of postive numbers. All I want to do is change them to
negative. They are all independent from each other and different. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change series of numbers from positive to negative
In an unused cell enter -1 and copy it.
Select the cells you want to change and paste/special with the multiply button checked -- Gary''s Student gsnu200708 "Wyatt Murphy" wrote: I have a series of postive numbers. All I want to do is change them to negative. They are all independent from each other and different. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change series of numbers from positive to negative
On Mar 1, 9:09 pm, Wyatt Murphy <Wyatt
wrote: I have a series of postive numbers. All I want to do is change them to negative. They are all independent from each other and different. Thanks! In blank cell enter -1, select it, copy, select range of cells with positive numbers, go to Edit - Paste special - in Paste Special dialog select Values and Multiply. -- Regards, Mladen_Dj http://excelancije.bloger.hr |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change series of numbers from positive to negative
Put -1 in an unused cell
Edit|copy that cell Select the range to fix edit|paste special|check multiply And clean up that cell with -1 in it. Wyatt Murphy wrote: I have a series of postive numbers. All I want to do is change them to negative. They are all independent from each other and different. Thanks! -- Dave Peterson |
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 | |||
change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
How do I change a column of 500 numbers from positive to negative | Excel Discussion (Misc queries) | |||
How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) |