Excel change a group of positive numbers to negitive numbers

C

Clare Jones

I believe you can easily change a group of positive numbers to negitive
numbers, but I can't remember how.
 
R

RonaldoOneNil

Enter -1 into an empty cell and then copy that cell.
Select your range of numbers and then do a paste special and select multiply.
 
L

Luke M

Formula way:
=-A1
or
=-ABS(A1)
if you want to keep negative values as negative.
or
other way is to input -1 into a cell somewhere, copy it, then do a paste
special, multiply.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

negitive and possitive numbers 4
spreadsheet with negitive numbers 1
How to count the numbers in a Word document? 0
How do I convert a column of positive numbers to negitive numbers 2
Coloring cells based on positive or negitive numbers 2
How can the font and size of (all) citation numbers be altered? 1
Header Roman Numeral to Regular Numbers 1
Excel does not accept text format! 0

Top