Changing Posative numbers to negative

P

Penny

Hi

I was wondering if it was possible to change a positive
number in Ecel to a negative number (in bulk so not by
putting a - sign in front of the number). I have 3000
cells that need to be made a negative number that are
posative.

Regards
 
J

Jordon

I was wondering if it was possible to change a positive
number in Ecel to a negative number (in bulk so not by
putting a - sign in front of the number). I have 3000
cells that need to be made a negative number that are
posative.
Click to expand...

=a1-(a1*2)

Jordon
 

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

Negative Numbers 8
Help with positive and negative numbers 1
pos & negative format?? 4
How do I display a "+" in front on positive numbers 3
Display plus sign for positive numbers 2
change a positive number to negative 16
Trying to reconcile a column 1
Negative numbers use braces 4

Top