=TRIM(TEXT(LEFT(SUBSTITUTE(A996,".",REPT(" ",99)),100),"000")&TEXT(MID(SUBSTITUTE(A996,".",REPT(" ",99)),100,100),"000")&TEXT(MID(SUBSTITUTE(A996,".",REPT(" ",99)),200,100),"000")&TEXT(MID(SUBSTITUTE(A996,".",REPT(" ",99)),300,100),"000"))
=TRIM(TEXT(LEFT(SUBSTITUTE(A996,".",REPT(" ",99)),100),"000")&TEXT(MID(SUBSTITUTE(A996,".",REPT(" ",99)),100,100),"000")&TEXT(MID(SUBSTITUTE(A996,".",REPT(" ",99)),200,100),"000")&TEXT(MID(SUBSTITUTE(A996,".",REPT(" ",99)),300,100),"000"))