View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dalene Dalene is offline
external usenet poster
 
Posts: 4
Default Import .csv File Problems

Hi,

I hope you can assist me. We have 2 problems with uploading data into Excel
from a .csv file:

1) Numbers longer than 11 digits - in this case vehicle part numbers €“
upload automatically in scientific format. As a result the part number gets
distorted and the user can not read the correct number in the cell. For
instance 8566463565562550 upload as 8.56646E+15.

2) Numbers with leading zeros are uploaded without the leading zeros, i.e.
0000001033 upload as 1033. The leading zeros must remain once imported.

Kind regards,

Dalene Bekker
Johannesburg, South Africa