how to tell excel to read numeric field as character fr a csv file
 

hi,
i have a csv file with some fields, one of the field which i want it to be
a character field, but the field contain only numeric, when excel open the
file, it became numeric, this may cause problem, cause the field is a credit
card number (e.g 1234567812345678 ), the excel will show 1.23457E+15, and the
actual value became 1234567812345670, that is totally wrong.

how can i do it without open the file, do some changes and save the file
again ?

rgds
Huat

how to tell excel to read numeric field as character fr a csv file
 

Change the file extension to TXT and import as a text file.
That will give you options per field

--
Kind regards,

Niek Otten

"Ang Kah Huat" wrote in message
...
hi,
i have a csv file with some fields, one of the field which i want it to
be
a character field, but the field contain only numeric, when excel open the
file, it became numeric, this may cause problem, cause the field is a
credit
card number (e.g 1234567812345678 ), the excel will show 1.23457E+15, and
the
actual value became 1234567812345670, that is totally wrong.

how can i do it without open the file, do some changes and save the file
again ?

rgds
Huat

how to tell excel to read numeric field as character fr a csv
 

hi,
Thanks, is it possible to do it without any human interface ? can the user
open the file and see the result correctly ? cause it have a lot of fields to
do so and this will be a daily file. we need to automate it.

rgds
Huat

"Niek Otten" wrote:

Change the file extension to TXT and import as a text file.
That will give you options per field

--
Kind regards,

Niek Otten

"Ang Kah Huat" wrote in message
...
hi,
i have a csv file with some fields, one of the field which i want it to
be
a character field, but the field contain only numeric, when excel open the
file, it became numeric, this may cause problem, cause the field is a
credit
card number (e.g 1234567812345678 ), the excel will show 1.23457E+15, and
the
actual value became 1234567812345670, that is totally wrong.

how can i do it without open the file, do some changes and save the file
again ?

rgds
Huat

how to tell excel to read numeric field as character fr a csv
 

Do it once manually, while recording a macro.

See

http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
Kind regards,

Niek Otten

"Ang Kah Huat" wrote in message
...
hi,
Thanks, is it possible to do it without any human interface ? can the user
open the file and see the result correctly ? cause it have a lot of fields
to
do so and this will be a daily file. we need to automate it.

rgds
Huat

"Niek Otten" wrote:

Change the file extension to TXT and import as a text file.
That will give you options per field

--
Kind regards,

Niek Otten

"Ang Kah Huat" wrote in message
...
hi,
i have a csv file with some fields, one of the field which i want it
to
be
a character field, but the field contain only numeric, when excel open
the
file, it became numeric, this may cause problem, cause the field is a
credit
card number (e.g 1234567812345678 ), the excel will show 1.23457E+15,
and
the
actual value became 1234567812345670, that is totally wrong.

how can i do it without open the file, do some changes and save the
file
again ?

rgds
Huat