| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number format in CSV file
Guys,
I'm creating a CSV file containing 13-digit barcode numbers. However, when opened in Excel they display in scientific notation. Any way I can cause Excel to load the numbers as text, or not use scientific notation, through the CSV file? Thanks, Simon. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number format in CSV file
If you rename your .csv file to .txt, you'll see the import wizard show up.
Then you can specify the delimiter and type of field (for each field). (or just format that column after you've imported the .csv file.) Simon wrote: Guys, I'm creating a CSV file containing 13-digit barcode numbers. However, when opened in Excel they display in scientific notation. Any way I can cause Excel to load the numbers as text, or not use scientific notation, through the CSV file? Thanks, Simon. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number in text format in CSV file | Excel Discussion (Misc queries) | |||
| Number Format on Excel File saved from .html file | Excel Discussion (Misc queries) | |||
| Time/ Number format on excel file exported from Access | Excel Discussion (Misc queries) | |||
| Loosing value of large number when saving file to CSV format | Excel Discussion (Misc queries) | |||
| How to format a number cell to auto count 1 up on file open | Excel Worksheet Functions | |||
Hybrid Mode
