Quote:
Originally Posted by beutelwolf
you want to convert a column of numbers that contains leading zeros to text so you can preserve the leading zeros. To force Excel to run the Import Text Wizard, you can change the file name extension from .csv to .txt before you open it, or you can Import a text file by connecting to it.
|
Aha! The mistake I made when importing before was still treating the fields as "General" rather than "text". Another MS wizard implicit behaviour "feature".
OK, I guess it's now worthwhile to re-do the data. /sigh!/
edit: new archive now uploaded, lnk in same place in other thread.