| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change format of a date field
I have been given a csv file - on opening in excel the dates are in the
format 25051917, 5051949, 23121979 etc. I have been struggling to get them into the standard date format - in this case 25/05/1917, 05/05/1949, 23/12/1979 etc. Any help appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format date and time from one contiguous field | Excel Discussion (Misc queries) | |||
| Help: format records (color) at each change in continious field | Excel Discussion (Misc queries) | |||
| Update date field upon cell range change | Excel Worksheet Functions | |||
| How do I format date field in footer? | New Users to Excel | |||
| How can I format a cell so date field only displays the Month? | Excel Discussion (Misc queries) | |||
Threaded Mode
