Let's assume that the row contains a mixture of positive and negative numbers.
Let's assume that we are talking about row #1.

In A2 enter:
=ABS(A1) and copy across.

Then copy row #2 and pastespecial/values back onto row #1
--
Gary''s Student - gsnu200856


"PL" wrote:

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

Thanks