Staff Id Generator

[Kahi]

Hello,
I need to generate staff Id numbers ,some body help me

 

[Khalid NGO]

Hi Kahi,
What kind of staff ID you need? Any sample?

 

[Kahi]

Hi Kahi,
What kind of staff ID you need? Any sample?

see attached file,where the first no,is id,then month and year, i.e 1 15 2013 hence 1152013

 

[Khalid NGO]

use this formula in F2:
=A2&TEXT(D2,"dmyyyy")

and copy down...

"dmyyyy" is format of text, you can change what ever you need.
i.e.

ddmmyyyy
ddmmyy
dd mm yy

 

[Kahi]

This is quite helpful however my preference is to at least six digits,I had tried out the auto generator but the challenge I had was to generate the I Ds to a specific cell see attached.I found this id generator on one of the threads,