Convert Text Field to Currency

[PJinMK1]

Can anybody advise how I can convert what seems to be a text field into a currency field?

I have a report which I have exported from a website but whatever I do I cannot convert this field into anything that I can subsequently use to run calculations on?

Can anybody help?

Thanks

 

[Gerald Higgins]

Hmm, I can't replicate this.

How is the value of £20.12 being created ?

 

[steve the fish]

Hmm, I can't replicate this.

I think you cant replicate that because the £ is your currency. I just tried with a $ and i get value error.

 

[Gerald Higgins]

Ah yes, steve the fish, that's it.

Perhaps a solution could be . . .
=right(D2,len(d2)-1)

 

[PJinMK1]

It was exactly that, thank you very much