Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am opening a comma-delimited CSV file using:
Workbooks.OpenText FileName:="InFile.csv", _ Origin:=xlMSDOS, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _ xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, _ Comma:=True, Space:=False, Other:=False, FieldInfo:=Array(Array(1, IsText), _ Array(2, IsText), Array(3, IsText), Array(4, IsText), Array(5, IsText), _ Array(6, IsText), Array(7, IsText), Array(8, IsText), Array(9, IsText)), _ TrailingMinusNumbers:=True One row has the text "5-10" in column H. No matter what I do Excel is determined to convert that cell to "10-May" and it changes the datatype for that cell to "Date". I would hate to have to "dump" Excel and go to pire VB for this project. Anyone have any ideas how to stop Excel from converting text to date? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CHANGE TEXT DATE TO NUMERIC DATE | Excel Worksheet Functions | |||
how do i change text format date to date (i.e., mm/yy to mm/dd/yyy | Excel Discussion (Misc queries) | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
Change text color of specific date range by macro in Excel | Excel Programming | |||
Change text to date and check against date in cell | Excel Programming |