Import Dropping Leading Zeroes
I am importing a comma delimited text file into an Excel
worksheet using Excel 97. Even though a field is
represented in the text file as "000234" (i.e. a text
field), it shows in the worksheet as 234.
How can I prevent the leading zeroes from being dropped?
Thanks
|