Extract Gender from I.D. Number

[LeilaniMerle]

Hi all, There has been a post previous to this regarding Extracting I.D. But I cannot seem to access it. Also that Solution has not worked for me.

1) I need to extract the gender (Male, or Female) from I.D. Numbers.

If my I.D is 580803 0162 086
The 7th Number tells the gender.

If that number is anything from 0-4 it is Female
If that number is anything from 5-9 it is Male

I am typing the number directly into a cell with no "I.D." IN front of it. e.g. (5808030162086) then i am formatting cell to number then getting rid of the decimals.

I am using Excel 2010 from Microsoft Office Professional 2010.

2) I seem to be having a problem when copying a formula to a cell, i.e. say from the internet. It will not work. I have ensured that "show formulas" is enabled.

Hope someone can assist me on these issues.

 

[AliGW]

Well thats what I mean. I installed MS Office using the British English, and so is it that that makes the difference? cause it only saw the semi-colon, not the comma.

My comment was to Aladin, but it's not the language setting in MS Office that matters, it is your computer's locale: if the formula works with the semi-colon, but not the comma, then you are NOT using a UK or US English-based locale setting in Windows.

 

[LeilaniMerle]

Ah ok then. Thank you so much.

I Live to learn

My comment was to Aladin, but it's not the language setting in MS Office that matters, it is your computer's locale: if the formula works with the semi-colon, but not the comma, then you are NOT using a UK or US English-based locale setting in Windows.

 

[Aladin Akyurek]

Just as a point of information, in case it matters here, the UK locale uses the comma instead of the semi-colon, too, in fact I believe all English-speaking locales do the same.

If they do so, I call it an American system, just because it behaves like an American system where in Excel the list separator is a comma, a decimal number uses a dot, and the date is m/d/yyyy.