Formating Issue

[Mglines]

I had to create a few VLook ups to format dates in an excel sheet.

The dates need to look like this 20100805 for Aug 8, 2010. I got that part right. I need that number to come over in a to look something like this 20100805T1500 CONCATENATE(YEAR(F2),MONTH(F2),DAY(F2),"T","1500"

The problem is when it comes over it looks like this 201085T1500.

I tried pulling it over like this CONCATENATE(F2,"T",1500) but then it gives me some number like 40395.625T1500.


I tried all kinds of formats but still have issues.

 

[Hui]

=CONCATENATE(TEXT(F2,"yyyymmdd"),"T",1500)

 

[Mglines]

that worked great thank you!