number as string with importing txt file

A

alfred wallace

How to keep the left zero(s) of a string in a cell by importing a simple
text file ?
thank you in advance
GH
 
G

Gord Dibben

Don't import the *.txt file.

Open it directly from File>Open.

The Text to Column Wizard will appear and let you choose the formatting of the
data as Text


Gord Dibben MS Excel MVP
 
Top