Maybe even more perfect, keeping as numeric for sorting.

Much thanks,

Steve

"macropod" wrote:

Hi Steve,

Here's a way that keeps the result as a numeric:
=VALUE(TEXT(H2,"yyyymmdd"))*100+I2

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Steve" wrote in message ...
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