I have Selling Price which is not in proper format as its converted from Dollar to our local currency.
So the amount in the column are ending with random number. I want to change last two numbers to 99.
For Eg.
324
2344
3322
234
I want to change this to
399
2399
3399
299
Can anyone help with some formula to do the same?