Thread: Convert YYYY, MM, and DD as a single number string
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
rmorrison rmorrison is offline
external usenet poster
  
Posts: 6
Default Convert YYYY, MM, and DD as a single number string
It's working now but the cell display reads:

39710.604976388939710.604976388939710.6049763889-101

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

"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