Formula - Convert cell information

[Leopold2000]

Hi,

I have 2 columns, one which includes the date and the other a sequence. Is there anyway to automatically use this information to create a third column that takes the date and sequence and converts into a standardised code?

The code is SD-DDMMYY-SEQUENCE.

So if in column A the date is 4 jan 2012 and the sequence is 02, the code generated would need to be SD-040112-02.

I have attached an excel which shows what I would like the formula to do..

Thanks,

Leo

[samba_ravi]

D2="sd-"&text(b2,"ddmmyy")&"-"&text(a2,"00")
try this and copy towards down