| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Date format changes
I get CSV files that I convert to .XSLX files. My problem lies with the
timestamps. They show as MM/DD/YYYY H:MM:SS ie: 08/03/2010 08:12:00. The problem is that this translates to August 3rd, 2010.... where it should actually be March 8th, 2010. I've tried going to Data--Text to column-- and selecting DMY, but this does nothing. I've used formula: =DATE(MID(D1,7,4), MID(D1,4,2),LEFT(D1,2))+TIMEVALUE(MID(D1,12,5)) --- but I get VALUE error. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 format cells to date format | Excel Discussion (Misc queries) | |||
| Excel Format Problem - Date Overrides Format | Excel Discussion (Misc queries) | |||
| Format an Excel Column in the window's short date format. | Excel Programming | |||
| How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Threaded Mode
