[Solved] Removing a Decimal point after a Number

[Zen1]

Hi

I have a number of individual cells with values like 5.39. , 4.79. 3.76. etc etc
I wish to remove the second decimal point after the number for all cells and other than find and replace for all of
the different figures (too many) I can't figure this one out.

Any help much appreciated

[JohnSUN-Pensioner]

Try format cells as number to prevent autoconvert data to dates and use Edit-Find&Replace with Search for `\.$` ("dot at the end of string"), empty Replace with and Regular expressions `ON`

[Zen1]

Worked a treat.

Thankyou so much