| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Date Format
I need help with data that i have exported from a database.
The date column is in a format i havent seen before 6093 Basically the "6" is for 2006, "093" is 93 days since the first of Jan. Can someone please help me use the date function to get this into dd/mm/yy format. Thanks in advance Hervinder |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell date format doesnt change | Excel Worksheet Functions | |||
| Enforcing a date format on a cell/column | Excel Discussion (Misc queries) | |||
| Change general format to US date format | Excel Discussion (Misc queries) | |||
| Customized Date Format | Excel Worksheet Functions | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
Threaded Mode
