We have a formula that extracts numbers from a text field. Thse are currency
amounts. Is there a formula that can put his into a number format?

'=IF(LEFT($E2,3)="CAD",RIGHT($E2,LEN($E2)-3),0)

Thank you!