Thread: Convert YYYY, MM, and DD as a single number string
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
  
Posts: 364
Default Convert YYYY, MM, and DD as a single number string
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?
Reply With QuoteReply With Quote