If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
I have a column of positive numbers that I need to change to negative numbers. Is there an easy way to do this? Right now I manualy make the change. Thank you, Pat
I have a column of positive numbers that I need to change to negative numbers. Is there an easy way to do this? Right now I manualy make the change. Thank you, Pat
patowens, put -1 in an empty cell, copy that cell, select the numbers you
want to change, right click and paste special, check multiply, OK.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"patowens" <patowens.1r2yqd_1119531909.571@excelforum-nospam.com> wrote in
message news:patowens.1r2yqd_1119531909.571@excelforum-nospam.com...
>
> I have a column of positive numbers that I need to change to negative
> numbers. Is there an easy way to do this? Right now I manualy make the
> change. Thank you, Pat
>
>
> --
> patowens
> ------------------------------------------------------------------------
> patowens's Profile:
> http://www.excelforum.com/member.php...o&userid=24567
> View this thread: http://www.excelforum.com/showthread...hreadid=381558
>
Your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"patowens" <patowens.1r3cmm_1119549918.3178@excelforum-nospam.com> wrote in
message news:patowens.1r3cmm_1119549918.3178@excelforum-nospam.com...
>
> Thank you for your replys. Your solution works great!
>
>
> --
> patowens
> ------------------------------------------------------------------------
> patowens's Profile:
> http://www.excelforum.com/member.php...o&userid=24567
> View this thread: http://www.excelforum.com/showthread...hreadid=381558
>
Change a positive number to negative number
patowens
Linear Mode
