Easy way to make negative data positive?

[Sarah]

I have a large section of negative data that I want to convert to positive
i.e. - 2 becomes 2 etc. Is there a quick way to do this? Thanks!

[Mike Middleton]

Sarah -

Select a blank cell somewhere and enter -1.

Edit | Copy.

Select the range of cells containing numbers to be converted.

Edit | Paste Special | Multiply.

- Mike
www.mikemiddleton.com

"Sarah" <[email protected]> wrote in message
news:[email protected]...
>I have a large section of negative data that I want to convert to positive
> i.e. - 2 becomes 2 etc. Is there a quick way to do this? Thanks!

[Sarah]

Aaaah - simple is best - thanks!

"Mike Middleton" wrote:

> Sarah -
>
> Select a blank cell somewhere and enter -1.
>
> Edit | Copy.
>
> Select the range of cells containing numbers to be converted.
>
> Edit | Paste Special | Multiply.
>
> - Mike
> www.mikemiddleton.com
>
> "Sarah" <[email protected]> wrote in message
> news:[email protected]...
> >I have a large section of negative data that I want to convert to positive
> > i.e. - 2 becomes 2 etc. Is there a quick way to do this? Thanks!
>
>
>