I wanted to know how, or if there is a formula to combine the date with a serial number (I have to inventory a lot of computers) to make an asset control number?
for example:
1/12/2012 607314099

to make 011212099

So I would be taking the date and adding the last 3 digits of the serial number to make the an asset control number. keep in mind that the date and serial number are in two different cells and I want the new number to be in the cell next to the serial number.

Can someone help me do this?