How to remove text from number

Hi all,

Would appreciate some help in devising a formula to remove two characters at the end of each number in my data set;

e.g.

89,554,181.58DR

8,457,847.48CR

I had previously used the suggested solution below with no success;

Thanks!

Accepted answers

If you want to go down that route, try the ReplaceChar function instead!

FYI.

Left([Txt], Length([Txt]) -2)

@Royalter21 You could use the data cleanse tool and selecting remove letters