I have done this before but drawing a blank. I have a clolumn with "001" and
it is in a file sales.csv. I format the coumn the file in this manner:
Format = Style - Custom - and put in 3 zeros. It then displays the leading
zeros. But when I open the file it goes away. Then when I tried to import
the files and I get errors because the 001 doesnt matchl. However, If I do
the format and save then it will import. But this is a file that I import a
lot. I get the file from one program and have to open it to format it and
resave before I can import. I done this before and I thought there was an
options I had to set in Excel also. Any help?