Search:

Thank you for the reply, hope this makes it clear

1st digit determines if it was Internet lead (1) or Phone (2)
2nd digit determines year 3 = 2013 and 4 = 2014 etc
3rd digit reads first 1st...

I need to convert a custom text to date in excel

If custom number is 137910O39

1st 1 = Internet 2 = Phone
2nd Year 3 = 13 and 4 = 14 etc
3rd Month ID 7 = 0 and 8 = 1 ...