Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Date" format after CSV import...
Gethi all
many thanks in anticipation. i am "importing" data from a CSV file by opening the CSV file in vba using GetOpenFilename. Once open, I am copy/pasting data from sheet(1) into previously active workbook into sheet(1), then closing the CSV file. The data imports OK, with the data in columns etc. What I have noticed is that the dates can be considered as "text" (ie left-aligned in cell) or "dates" (right-aligned). While IsDate() recognised both as dates, any date function / analysis does not correctly interpret the date in the former. If i select cell formatting and choose "date" etc, it doesn't make any difference to the cell. The only data option i have found to change the format is to use "text-to-columns" on that column... which itself can introduce some errors... i really need a way to debug the dates to ensure they are valid, and will be processed correctly. many thanks Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
retain custom date format "text" when pasting or reformatting data | Excel Discussion (Misc queries) | |||
Using VBA to change a cell format to date doesn't get "committed" | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Import HTML data into Excel - data in "1-1" format translates to J | Excel Discussion (Misc queries) | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) |