Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
One of our databases churns out a 5 digit date such as 10410 is
October 2004. The 1st 3 characters indicate the year (e.g., 107 is 2007, 106 is 2006, etc) and the last 2 characters indicate the month. Is there a custom date format that would make it easier to read, and have the result appear to be: Apr-07, or the like? Thanks for any ideas. Pierre |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Date & Time format | Excel Worksheet Functions | |||
Date Format in Custom Header | Excel Discussion (Misc queries) | |||
Custom format date | New Users to Excel | |||
Custom Date format ie. 01.01.05 W1 (W1 is week 1) | Excel Discussion (Misc queries) | |||
How to write a "Text" or date custom format | Excel Worksheet Functions |