software

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
HuatChange the file extension to TXT and import as a text file.
That will give you options per field

--
Kind regards,

Niek Otten

quot;Ang Kah Huatquot; gt; wrote in message
...
gt; hi,
gt; i have a csv file with some fields, one of the field which i want it to
gt; be
gt; a character field, but the field contain only numeric, when excel open the
gt; file, it became numeric, this may cause problem, cause the field is a
gt; credit
gt; card number (e.g 1234567812345678 ), the excel will show 1.23457E 15, and
gt; the
gt; actual value became 1234567812345670, that is totally wrong.
gt;
gt; how can i do it without open the file, do some changes and save the file
gt; again ?
gt;
gt; rgds
gt; Huat
gt;
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

quot;Niek Ottenquot; wrote:

gt; Change the file extension to TXT and import as a text file.
gt; That will give you options per field
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Ang Kah Huatquot; gt; wrote in message
gt; ...
gt; gt; hi,
gt; gt; i have a csv file with some fields, one of the field which i want it to
gt; gt; be
gt; gt; a character field, but the field contain only numeric, when excel open the
gt; gt; file, it became numeric, this may cause problem, cause the field is a
gt; gt; credit
gt; gt; card number (e.g 1234567812345678 ), the excel will show 1.23457E 15, and
gt; gt; the
gt; gt; actual value became 1234567812345670, that is totally wrong.
gt; gt;
gt; gt; how can i do it without open the file, do some changes and save the file
gt; gt; again ?
gt; gt;
gt; gt; rgds
gt; gt; Huat
gt; gt;
gt;
gt;
gt;

Do it once manually, while recording a macro.

See

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

--
Kind regards,

Niek Otten

quot;Ang Kah Huatquot; gt; wrote in message
...
gt; hi,
gt; Thanks, is it possible to do it without any human interface ? can the user
gt; open the file and see the result correctly ? cause it have a lot of fields
gt; to
gt; do so and this will be a daily file. we need to automate it.
gt;
gt; rgds
gt; Huat
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt;gt; Change the file extension to TXT and import as a text file.
gt;gt; That will give you options per field
gt;gt;
gt;gt; --
gt;gt; Kind regards,
gt;gt;
gt;gt; Niek Otten
gt;gt;
gt;gt; quot;Ang Kah Huatquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; hi,
gt;gt; gt; i have a csv file with some fields, one of the field which i want it
gt;gt; gt; to
gt;gt; gt; be
gt;gt; gt; a character field, but the field contain only numeric, when excel open
gt;gt; gt; the
gt;gt; gt; file, it became numeric, this may cause problem, cause the field is a
gt;gt; gt; credit
gt;gt; gt; card number (e.g 1234567812345678 ), the excel will show 1.23457E 15,
gt;gt; gt; and
gt;gt; gt; the
gt;gt; gt; actual value became 1234567812345670, that is totally wrong.
gt;gt; gt;
gt;gt; gt; how can i do it without open the file, do some changes and save the
gt;gt; gt; file
gt;gt; gt; again ?
gt;gt; gt;
gt;gt; gt; rgds
gt;gt; gt; Huat
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;