Excel formula help - remove character from a certain position within a string

[p4nny]

Hi

I would like to replace the the last "." with a "0"

[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]1.1.7[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64"]1.1.8[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64"]1.1.9[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64"]1.1.10[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64"]1.1.11[/TD]
[/TR]
</tbody>[/TABLE]

Much appreciated

 

[wideboydixon]

Book1
	A	B
1	1.1.7	1.107
2	1.1.8	1.108
3	1.1.9	1.109
4	1.1.10	1.1010
5	1.1.11	1.1011
6	1.1.1.1.1.1	1.1.1.1.101
7	2	2
Sheet1

Cell Formulas
Range	Formula
B1	=IFERROR(SUBSTITUTE($A1,".","0",LEN($A1)-LEN(SUBSTITUTE($A1,".",""))),$A1)

WBD

 

[p4nny]

many thanks