Enter -1 in a cell.

Copy that cell.

Select the range of negative numbers and EditPaste SpecialMultiplyOKEsc.

No need for helper column.


Gord Dibben MS Excel MVP

On Sat, 13 Jun 2009 02:14:01 -0700, PL wrote:

How do I change all the numbers in a row into positive ones without doing so
individually?

Thanks