Display time in text
That's work ... Thanks a lot ....
Smart GUY !!!
"Gary''s Student" wrote:
In A1 enter:
FileName
in A2 enter:
=TEXT(TODAY(),"yyyymmdd")
elsewhere enter:
=A1 & A2
to display:
FileName20090429
--
Gary''s Student - gsnu200850
"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 !
|