Is there a formula which could change -£1.50 to £1.50 in Excel?

  • Thread starter Thread starter MichaelOfficer
  • Start date Start date
M

MichaelOfficer

It's a pain,but my accounting software reports my cheque values as minus.

To be useful in the spreadsheet they should be positive numbers, - but there
are hundreds!

could you please help me?
 
It's a pain,but my accounting software reports my cheque values as minus.

To be useful in the spreadsheet they should be positive numbers, - but there
are hundreds!

could you please help me?
Click to expand...

Assuming your value is in A1 : =ABS(A1)
 
Back
Top