Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date format problems after csv import
Dear all Excel expert,
I am facing 2 date problems after importing from a sql database via .csv. This field is a date + time field. Appreciate any help. Thanks in advance. Problem 1: Even during import, I select field as D/M/Y, but the date is imported in Excel date format(Custom m/d/yyyy hh:mm). eg. 4/1/2010 11:58 has become 1st April. How can I convert this to the correct date which is actually 4th Jan? I would like the result to be in Excel date format to be mm/dd/yyyy hh:mm Problem 2: For any dates that are 12, the value is exported as text '29/01/2010 9:28 How can I convert this to the same format as Problem 1?, ie. Excel date format to be mm/dd/yyyy hh:mm regards, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with entry of date format | Excel Discussion (Misc queries) | |||
Date format problems | Charts and Charting in Excel | |||
Date format problems ... | Excel Discussion (Misc queries) | |||
Date format problems when used in different countries | Excel Discussion (Misc queries) | |||
Date Format Problems?? | Excel Discussion (Misc queries) |