Display time in text
Do it this way:
=A1 & TEXT(A2,"yyyymmdd")
assuming your filename is in A1 and the date in A2.
Hope this helps.
Pete
On Apr 29, 10:07*am, Elton Law
wrote:
Dear expert,
Want to display date in 20090429. I go to format and choose YYYYMMDD.
It works. Then I use "concatenate" or "=A1&A2"
It becomes 39932. The fact is that I want to concatenate a file name and add
date at the back for saving purpose.
I have tried ...
=Year(A1)
=Month(A1)
=Date(A1)
But it gives 2009429 rather than 20090429.
I changed number format to 00.00 in order to display 04 for month. it works
for display only .... but concatenate ... it becomes 2009429 again.
Also, I have tried TEXT(A2,"00") and concatenate ... does not work too !
|