Is there an easy way to change a range of cells containing number.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there an easy way to change a range of cells containing numbers from
positive to negative?
 
Hi
- enter -1 in an empty cell
- copy this cell
- select your data
- goto 'Edit - paste Special' and choose 'Multiply'
 
You must log in or register to reply here.

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

Flipping numeric values 3
Min and Max Dates in Range that Contains Zeroes, Dates, and Number 5
Change the sign on all numbers in a spread sheet 2
Question about conditional formatting of zeros in Excel 0
changing signs in formulas and cells 1
COUNTIF Cells in Range? 4
Firefox Multi-Account Containers 1
adding cells that contain a formula 3

Back
Top