Importing CSV-File with formatting informations
Imaging a file containing a CPR-number (eg social security-number) in column
1 and name in column 2, like this
0101612342;Michael Jackson
0202655431;Janet Jackson
In column 1 there can be leading 0 (zeroes), which I want to keep.
When I import I want to to avoid to use the wizzard to make the column to be
text every time, I want Excel to do it automatical.
I have tried to do it like "0101612342";"Michael Jackson", but it wont work.
I would be very happy, if I can get help to this.
|