how to convert date type to text type

[Guest]

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,??).

 

[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

 

[Guest]

ok,if i just want use y m d data,how to set ?

?? is any of the date format codes that you want to use.

For example:

=text(a1,"yyyy-m-d")


--ron

 

[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