How to remove text from number

[Royalter21]

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!

[alexnajm]

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

[Swathi]

[nagakavyasri]

@Royalter21 

[flying008]

Hi, @Royalter21 

FYI.

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

[aatalai]

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