Hi David,
What do you suggest we do about this problem? Is there a way we can request
Microsoft to write a patch or solution for us?

Eagerly awaiting your reply.....

Regards,
Dalene Bekker

"David Biddulph" wrote:

As an alternative to renaming from csv to txt, another way of imposing the
text import wizard is to use Data/ Import External Data ...
--
David Biddulph

"Gary''s Student" wrote in message
...
Excel is trying to "help" you. To avoid this help, rename the file to
.txt
rather than .csv

This will bring up the Imporet Wizard when you open the file with Excel.
Just tell the Wizard to treat the field as Text rather than General.
--
Gary''s Student - gsnu200763


"Dalene" wrote:

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