Ask Experts Questions for FREE Help !
Ask

Search:

Type: Posts; User: terra999

Search: Search took 0.00 seconds.

  1. Answers
    3
    Views
    1,927

    Thank you for the reply, hope this makes it clear...

    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...
  2. Answers
    3
    Views
    1,927

    Create date from custom text string in excel

    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 ...
Results 1 to 2 of 2