Converting Identification Number to Birthday

Tech-Archive recommends: Speed Up your PC by fixing your registry

I have a cell (A1) that could contain one of two types of data:

1) Passport Number which is in the format of "PXXXXX" where X = numeric
digits.
2) a standard ID number which has the format "YYMMDD XXXX XX X" where the
first 6 digits represent the persons birth date. I need a formula that will
look into the data entered into A1, and:

If the entered data is in the format of the Passport Number, do nothing.
If the entered data is in the format of the id number, extract the day and
month of the persons birthdate and place that data in B1, with the format '15
Feb" - not showing the year value.
.

Relevant Pages

  • Re: Calculation in text box on form
    ... birth expressed with four digits for the year, or with just two digits (and ... > I have a text box on a form that calculates a persons age using the ... > The format to display the age on the form is yy ...
    (microsoft.public.access.formscoding)
  • RE: Converting Identification Number to Birthday
    ... Format Column B Cells to ... "WildWill" wrote: ... first 6 digits represent the persons birth date. ... If the entered data is in the format of the Passport Number, ...
    (microsoft.public.excel.misc)
  • Re: Custom date format not working in ACC2003
    ... It forces the year to display as 4 digits in dates, ... setting the Format of the control won't rescue it. ... the date fields in reports always format ...
    (microsoft.public.access.reports)
  • Re: Price Data Formatting
    ... I'm loading into the application price data that has a format I do not know ... Since price data format is all dependent on the market selected (say IBM ... rounded/truncated to 2 digits following the decimal as well. ... Dim sStr As String ...
    (microsoft.public.vb.general.discussion)
  • Re: Format Problem
    ... I set the numberformat property to General and it still does ... for the long date format. ... for the month and date separator, and displays two digits for the year. ... Currency Displays a number according to the Windows regional ...
    (microsoft.public.excel.programming)