Progressively adding part of a cell

[Doglover]

Hi, hopefully this is simple, but I haven't been able to find a thread pertaining to my problem.

I have thousands of products which have (as an example) the progression
33.0 mm, in the next cell 35.0 mm, then 37.0 mm, etc. or sometimes they have a different number in the decimal space (of course)

I tried the following formula:
=MID(F13640,1,4)+2&" "&MID(F13640,6,2)

which worked but the decimal didn't carry through, so I tried:
=MID(F13640,1,4)+2&".0 "&MID(F13640,6,2)

which worked, but it won't work with anything other than .0 after the number. Is there a way to add a value progressively to just a part of the cell, while still resulting in the correct number of digits? Thanks so much in advance!

 

[schielrn]

Sorry, I must have done something funky the first time I tested.

No problem, if you put any number other than 0 it will always end in that number.

 

[Doglover]

All three of those options work well and I actually think I could adapt it for an extra decimal if I needed to...at least for the third formula I could!!! Lol...I need to figure out how those worked, but thank you so much for your help!!!