Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In our country all citizens have a unique [13digit] identity number, the
first 6 digits being date of bitrh. I've tried to convert these 6 digits to date of birth, without any luck. The main problem being the year of birth forms the first 2 digits, ie a person born on 10 February 1952 IDnumber would be 520210[plus 7 digits] . Any help would be appreciated HJN |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting Negative Number to Postive number | Excel Worksheet Functions | |||
converting a positive number to neg number in spreadsheets | Excel Discussion (Misc queries) | |||
Converting a negative number to a positive number | Excel Discussion (Misc queries) | |||
Fill FromDate to ToDate | Excel Programming | |||
converting number string to number with decimal | Excel Worksheet Functions |