Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Does anyone know if it is possible to configure Excel to recognize
that when opening a .CSV file, the Import Wizard should be used? We use a lot of .CSV files here, and many users have problems when they double-click the file icon to open it. If there are columns with numerical data, excel will convert them to numbers and then will often change them by truncating leading zeros, or converting them to exponential values if they are many digits. The standard solution for this is to open Excel and then initiate the import wizard, but it would be nice if Excel could be set to automatically recognize, by file type, that the import wizard should be used. I am reasonably capable with Excel myself and doubt that this option exists, but the expert knowledge within this forum gives me hope that if this can be done, someone here will know how. Thanks very much, TK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
PLEASE!! How can I un-grey the 'Data-Import External Data-Import Data' option ??? | Excel Programming | |||
Checking & Forcing Data Entry in Cells | Excel Discussion (Misc queries) | |||
Forcing data into a cell | Excel Worksheet Functions | |||
Forcing data value in a cell | Excel Discussion (Misc queries) |