Thread: Changing display of value with multiple decimal points

There might be a shorter way..but

If you put this formula in an adjacent cell:

=TEXT(0+TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",100)),1,100)),"00.")&TEXT(0+TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",100)),100,100)),"00.")&TEXT(0+TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",100)),200,100)),"00.")&TEXT(0+TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",100)),300,100)),"000")

Where A1 represents first cell to parse.

Then copy down to convert all,

Then you can copy this column and paste special >> Values over your original column and delete the formula column.

If by any chance you meant 00.00.000.000 (given the last of your examples has three digits in third sub section) then another alternative might be to convert the original to a number and apply a Custom Format

Assume original values in A1, A2 etc then:

B1:
=SUMPRODUCT(10^{8;6;3;0}*MID(SUBSTITUTE(A1,".",REPT(" ",LEN(A1))),1+LEN(A1)*{0;1;2;3},LEN(A1)))
copied down

Custom Format to B1:Bn of: 00\.00\.000\.000

However, I suspect the above fails requirements... thought I'd post it just in case.