S
Steffen
i want to convert a cell a1 2007-7-8 to a text type, but i did not know how
to set the second parameter of text function.
text(a1,??).
to set the second parameter of text function.
text(a1,??).
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron Rosenfeld
i want to convert a cell a1 2007-7-8 to a text type, but i did not know how
to set the second parameter of text function.
text(a1,??).
?? is any of the date format codes that you want to use.
For example:
=text(a1,"yyyy-m-d")
--ron
S
Steffen
ok,if i just want use y m d data,how to set ?
Ron Rosenfeld said:?? is any of the date format codes that you want to use.
For example:
=text(a1,"yyyy-m-d")
--ron
R
Ron Rosenfeld
ok,if i just want use y m d data,how to set ?
I don't understand your question.
What is "y m d data"?
How do you want to "use" it?
In the formula I gave you, A1 must contain a date (which, in Excel,is a serial
number).
--ron