пятница, 18 февраля 2011 г.

Reading Numbers as Strings from .csv file

When Excel opens a csv file it processes it automatically, and displays numbers using a general format.

If you want to bring these fields in with leading zeros, you could change the file to a txt file (by changing the suffix), and then open it with Excel. This will bring up the text file wizard, which has options to treat the field as text. This will retain leading zeroes.

Комментариев нет: