cell values

G

Gary''s Student

In an un-used cell enter -1 and then copy this cell. Then select the cells
you want to change and Paste/Special/Multiply
 
M

Max

Derek Dainton said:
How do you convert negative cell number entries to positive?
Click to expand...

One way, assuming numbers (positives, negatives, with maybe some blank
cells) are in A2 down, you could place in B2, copied down:
=IF(A2="","",ABS(A2))
 
M

Max

The earlier suggestion assumes that the conversion is to be applied only for
the negatives in the entire col, viz you would want to leave positives as
positives & the blanks as "blanks"
 
Top