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)

Please Login or Register  to view this content.

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.

[shg]

Why not format as text beforehand?

[Rick_Stanich]

For the first instance of the serial number I had tried this, still lost the leading zero (perhaps I did somethign wrong); also I am unable to find each instance of the serial number (Row is unknown and there can be many). Cant search for what isnt there.
Example: If I import 10 files to process, there could be upto 10 different serial numbers. Some files can have the same serial number as they may be part one of X.

The example in my inital post is the first few lines (rows) from a .txt file.

[shg]

When you open the file from Excel, you specify space as the delimiter, true?

In the same process, you can import all fileds as text. And automate it if you wish ...

[Rick_Stanich]

Yes to "space delimeter" and are you speaking of a text qualifier?

This is the function I use (Thanks to this forum).

Please Login or Register  to view this content.

[shg]

Gotta bow out, Rick, I don't use query tables. I'm sure someone else here can help though.

[Rick_Stanich]

No worries, thanks for trying.