Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How come I can't import an .svc file(Open Office) to Excel file? | Excel Discussion (Misc queries) | |||
Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
Excel & Access Import Problems | Excel Discussion (Misc queries) | |||
Import external data problems | Excel Discussion (Misc queries) | |||
Excel import problems | Excel Discussion (Misc queries) |