One way:

A1 = -10

Formula in B1:

=ABS(A1)

Returns 10

--
Biff
Microsoft Excel MVP


"UniStudent Coll" wrote in
message ...
If you have a column of negative and positive numbers, how do you transfer
these numbers all to be positive in the next column?

FC