Changing a positive number to a negative number...

[lynneb]

I tried using the replace function- but could not figure out how to change a positive amount to a negative amound easily...

Anyone know a quick way to do this another way?

Thanks!

[Von Pookie]

If you download the ASAP Utilities add in, there is an option to do just what you are looking for with a couple clicks of the mouse

[maxflia10]

Try ASAP utilities

http://www.asap-utilities

[plettieri]

Hi

ASAP utilities has a nice feature that does exactly that...

Free Download ASAP-UTLTITIES


hope this helps

pll

[ This Message was edited by: plettieri on 2002-10-24 12:23 ]

[Mark W.]

On 2002-10-24 12:19, lynneb wrote:
I tried using the replace function- but could not figure out how to change a positive amount to a negative amound easily...

Anyone know a quick way to do this another way?

Thanks!

1. Enter -1 into an unused cell
2. Copy the cell containing -1
3. Select the values you want to change
4. Paste Special... Values Multiply
5. Clear cell containing value entered at step 1.

[lynneb]

Thanks Downloading it now

[DonkeyOte]

say numbers in A1 etc...

B1 = if(a1<0,-a1,a1)

[IML]

Another formula option
=-ABS(A1)

[lynneb]

Thanks everyone....! I installed it and wow- gonna save my sanity here