| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
| Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
| Excel File - Read Only Error | Excel Discussion (Misc queries) | |||
| how do i read an 2000 office Premium Excel file? I don't have the. | Excel Discussion (Misc queries) | |||
| Excel Viewer Won't Read xls file! | Excel Discussion (Misc queries) | |||
Threaded Mode
