Keep leading zeros (Unknown locations)

[Rick_Stanich]

How can I keep leading zeros without formatting a cell to text. I wont know where the cell(s) will be located.

Example import text file: (not imported)

PARTSN_PARTSN_1: SN 090611 .   
TOLA:0    FLATNESS         TA(#738,13G7)                FA(PLA_1)
  NOM=0.0040     ACT=0.0007                             PCT=17.2891                             |+...| IN
TOLA:1    DIAMETER         TA(#691,11D3)                FA(CIR_2)
  NOM=0.2494      UPPER=0.0005  LOWER=0.0000            ACT=0.2497      DEV=0.0003              |+++.| IN
TOLA:2    PERPENDICULARITY TA(#693,11D3)        RFS     FA(LIN_0)
  NOM=0.0005                                            ACT=0.0003     PCT=59.2753              |+++.| IN

The first line would be seperated into cells such as: (The only known locations)
A1. PARTSN_PARTSN_1:
B1. SN
C1. 090611

I do not know where this line will fall inot next.
PARTSN_PARTSN_1: SN 090611 .

As it is it gets converted to "90611.0000" (Loss of leading zero)
And I need it to be "090611".

The number in Red allways changes, it is an assigned serial number. It can be numeric, alpha\numeric, numeric\alpha.
One thing is certain, if it has a leading zero, it must retain the leading zero.

Any hints, tips and or examples is appreciated.