| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates converted
I need to find a formula to change a production date into a 2 letter
cypher. The months are for instance aug = A, sept= B, oct = C, etc the years are 2012 = W, 2013=X, 2014=Y, 2015=Z, 2016=A So a complte date is described as JW18 for 18 may 2012 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates converted into text | Excel Programming | |||
| Excel converted numbers to dates suddenly in All Sheets!!!! | Excel Discussion (Misc queries) | |||
| dd/mm converted to mm/dd | Excel Programming | |||
| Answer to 2/29 gets converted to 2/1 | Excel Discussion (Misc queries) | |||
| How do I import fractions without data being converted to dates? | Excel Discussion (Misc queries) | |||
Threaded Mode
