Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi. All,
Easy one for the experts. My country use a unique [13 number-digit] Identification system. The first 6-digits represent the date of birth [yymmdd] In my code the ID number is entered on a userform as text and displayed as follows 52-02-08-5034-087 [in this example the d.of b is 8-Feb-1952] Range("Bithday").Value = Left(Idnumber, 8) displays the required birthday in Range("Bithday") With the note "This cell contains a date string represented with only 2 digits for the year." If I select the option "Convert XX to 19XX" it gives me exactly what I want. I tried macro record but it doesnt give me any result. How do I include the "Convert XX to 19XX" in my code ? -- HJN |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatically convert Text with 2-digit year | Excel Discussion (Misc queries) | |||
convert day of year to numeric value format year+day in 4 digits | Excel Worksheet Functions | |||
Addendum to 2 digit year to 4 digit year | Excel Discussion (Misc queries) | |||
Format 2 digit year to 4 digit | Excel Discussion (Misc queries) | |||
Convert 2 digit month to 4 digit years and months | Excel Worksheet Functions |