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

[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?

 

[Pete_UK]

I answered a very similar enquiry just a few days ago - you can see it
here:

http://groups.google.com/group/micr...f2b2594ead2/68044c69c131a456#68044c69c131a456

Hope this helps.

Pete

 

[Yanick]

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?

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