if you want it as text
=text(H2,"yyyymmdd")&I2

"Steve" wrote:

I have the date 7/21/07(seniority date) formatted as yyyymmdd = 20070721
In the next column I have other numbers , e.g. 1 thru 13 ( seniority numbers)
I need in the 3rd column the seniority date 20070721 and the seniority
number 13 combined to = 2007072113

Formula =H2&I2 is producing 3928413

and

I can't figure out to get that formatting to produce 207072113, which would
further need to be able to be sorted.

Thanks,

Steve