Hi all,

I have several cells containing numbers, and also either DB or CR depending on whether the amount is positive or negative.

Eg. 100,000 DB would be -100,000
100,000 CR would be +100,000

I need to work out a way to convert the cells from the DB/CR format to a number format so that they can be used in formulas.

Does anyone have an idea as to how i might go about doing this?

Thanks