How to convert a negative value to positive?

[ianccy]

i have a cell with negative value, how to format it to positive no.? Do i have to use a formula?

 

[Cam]

you can do it with a formula.

=ABS(a1)

where a1 is the cell you wish to make positive.

 

[lenze]

This depends on what you want.

If you need to keep the value negative for other calculations, but want it not to display as a negative, use custom formatting

###;###;

If you want to change the value, enter a -1 in a cell. Copy, and then paste over your negative values, using Paste Special>Multiply

 

[Cam]

You could custom format it to ;0; it's a bit shorter, and it will still retain it's negative value without showing the - sign.

 

[ianccy]

ya, thank you i was hit by something, i just remembered, tks anyway