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 !