simple query changing set of numbers from positive to negative

  • Thread starter Thread starter sammy
  • Start date Start date
S

sammy

have a string of numbers in a column that are positive and would like to
make negative

ie

1384.40
128.31
193.7
....
and would like to make place minus in front
ie

-1384.40
-128.31
-193.7
....

Appreciate advice
Sammy
 
Put -1 in an empty cell, copy it, select the numbers and do edit>paste
special and select 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

Help with positive and negative numbers 1
Negative Numbers 8
change a positive number to negative 16
Change negative nmbr to positive 7
Conditional Formatting based on positive/negative numbers 2
Excel - Adding positive or negative numbers in a column 5
How do I display a "+" in front on positive numbers 3
Columns negative to positive 2

Back
Top