Turn a row of numbers into negative value

[[email protected]]

Hi Folks

Am using Excel 2002.

I have a column of data like this:
5, 16, 27, 38, 39

Is it a fast and automatic way of turning all these into negative....
that reads
-5, -16, -27, -38, -39


Thanks!

[Dave Peterson]

put -1 in an empty cell
edit|copy (that cell)
select your range to fix
edit|paste special|check multiply
clean up that cell with -1 in it.

"[email protected]" wrote:
>
> Hi Folks
>
> Am using Excel 2002.
>
> I have a column of data like this:
> 5, 16, 27, 38, 39
>
> Is it a fast and automatic way of turning all these into negative....
> that reads
> -5, -16, -27, -38, -39
>
> Thanks!

--

Dave Peterson

[Max]

If the col of numbers is in col A,
we could also put in say, B1: =A1*-1, and copy B1 down
(Then use col B for further calcs, etc)

Or, if the col A may also contain negative numbers
which are to be left untouched (say),
then we could use instead in B1: =IF(A1>0,A1*-1,A1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
<[email protected]> wrote in message
news:[email protected]...
> Hi Folks
>
> Am using Excel 2002.
>
> I have a column of data like this:
> 5, 16, 27, 38, 39
>
> Is it a fast and automatic way of turning all these into negative....
> that reads
> -5, -16, -27, -38, -39
>
>
> Thanks!
>

[Mikeopolo]

Or, if the values may already contain negatives, and you want to retain those, if values start in A1, then type

=min(a1,-a1) into B1

and copy that down to the column

Regards
Mike

[Max]

"Mikeopolo" wrote:
> Or, if the values may already contain negatives,
> and you want to retain those, if values start in A1, then type
> =min(a1,-a1) into B1

Much neater, thanks !

and even the earlier
> ... B1: =A1*-1

should also be just B1: = -A1 <g>
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---