View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FinnAndersen FinnAndersen is offline
external usenet poster
 
Posts: 2
Default 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.