| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing Data - overriding auto format
I am importing CSV files using a macro. In one column I have data that looks like dates - eg 10-12, 11-09 etc which Excel automtically thinks this is a date and puts Oct-12 or Nov-09 (or their numerical equivalent to be precise) into the cell. Can I override this and tell excel (in VB) that column 1 is text not date
Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Importing Data - overriding auto format
I believe you would custom format the column "00-00" before the data is
imported. Mike "Max Scott" wrote in message ... I am importing CSV files using a macro. In one column I have data that looks like dates - eg 10-12, 11-09 etc which Excel automtically thinks this is a date and puts Oct-12 or Nov-09 (or their numerical equivalent to be precise) into the cell. Can I override this and tell excel (in VB) that column 1 is text not date. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing data from another spreadsheet to a different format | Excel Discussion (Misc queries) | |||
| conditional format overriding border | Excel Discussion (Misc queries) | |||
| cell format options when importing data | Excel Discussion (Misc queries) | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| Auto Importing of text fiel data | Excel Programming | |||
![Max Scott[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
