column of negative numbers into positive numbers

O

ORLFREIGHTBOY

Hello all-

If I have a column of negative numbers and I want them all to become
positive numbers (-500 becomes 500, etc.), is there a quick way to do this?
Also, if the column has a positive number in it, I would that to become
negative...
Thanks - Jason
 
D

David Biddulph

Put -1 in a spare cell, select and copy, select your column, edit/ paste
special/ multiply. Delete your -1 now you've finished with it.
 

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

Program buttons to create a word document 0
Automatically Scheduled Task with Start on Constraint and Neg Slack 0
Possible to Combine reports to's to a single box? 0
SUMIF with broken range 10
I have a column of 50 numbers 1
I have a column of 50 numbers 1
CONDITIONAL FORMATTING & NEGATIVE VALUES 1
I have a column of 50 numbers 1

Top