View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ang Kah Huat
 
Posts: n/a
Default 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