This shoud work. Did you test this out?

"Peo Sjoblom" wrote:

Looks like you have real dates and times in your cells

=TEXT(A1,"YYYY")&TEXT(B1,"MM")&TEXT(C1,"DD")&" - "&D1





--


Regards,


Peo Sjoblom

"rmorrison" wrote in message
...
The value now displays

39710.604976388939710.604976388939710.6049763889-101

It should display 20080919-0101. It doesn't seem to be working.

"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?