Yes, all components are in different cells and tabs within the same file. I
entered the formula below but only the test displays in the cell, not the
formula value. How do I fix this?

='Lookup Table'!A423&'Lookup Table'!A425&'Lookup Table'!A427&"-"&B4

"Sheeloo" wrote:

Requirement not clear. Do you want YYYYMMDD-#### in a cell and you have all
the components in different cells?

Enter this in F1
=A1&B1$C1&"-"&D1 assuming you have the above in Col A-D


"rmorrison" wrote:

I have YYYY, MM, and DD entered in separate cells in Excel 2007. I want to
create a new Job Number with YYYYMMDD-####, where #### is a new job which is
attached to the date string. How do I do this?