Converting date into text format
This is related to my previous post.
I need to convert a date in yyyymmdd format to text. i,e, 20080421 converts to the number 39559 when added to a CONCATENATE function. is there a way for the 20080421 to be added to the CONCATENATE function instead of the raw Excel date number? Thanks, Dan |
Converting date into text format
=concatenate(TEXT(A1,"yyyymmdd"),...)
-- David Biddulph wrote in message ... This is related to my previous post. I need to convert a date in yyyymmdd format to text. i,e, 20080421 converts to the number 39559 when added to a CONCATENATE function. is there a way for the 20080421 to be added to the CONCATENATE function instead of the raw Excel date number? Thanks, Dan |
All times are GMT +1. The time now is 12:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com