| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
import csv without automatic date conversion
When I import a csv file with fields in the format "n/n" where n is any
integer, Excel automatically converts that field into a date, i.e. "Jan-01." How do I stop Excel from doing the automatic conversion? I want to keep the data in its original format. I'm using Excel 2000 9.0.3821. Thanks. |
|
#2
|
|||
|
|||
|
You need to rename the file to txt then use the text import wizard and import
the n/n/ as text in step 3 Regards, Peo Sjoblom "shinta" wrote: When I import a csv file with fields in the format "n/n" where n is any integer, Excel automatically converts that field into a date, i.e. "Jan-01." How do I stop Excel from doing the automatic conversion? I want to keep the data in its original format. I'm using Excel 2000 9.0.3821. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date conversion issue "^" symbol | Excel Discussion (Misc queries) | |||
| Date Conversion | Excel Discussion (Misc queries) | |||
| unwanted number to date conversion while pasting data from web | Excel Worksheet Functions | |||
| Automatic Data Import | Excel Discussion (Misc queries) | |||
| Disable automatic date conversion feature | Excel Worksheet Functions | |||
Linear Mode
