On Mon, 16 Jul 2007 19:32:02 -0700, Steffen
wrote:

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