Convert Date to Text
 

Hi Folks - I have a date in the following format: 2008-09-24. Is there a way
to convert this to text so it displays as 2008-09-24? Thanks.

Michael

Convert Date to Text
 

You could use a helper cell:
=text(a1,"yyyy-mm-dd")

Michael wrote:

Hi Folks - I have a date in the following format: 2008-09-24. Is there a way
to convert this to text so it displays as 2008-09-24? Thanks.

Michael

--

Dave Peterson

Convert Date to Text
 

=TEXT(A2,"yyyy-mm-dd")

using a help column then copy and paste special as values over the old
if they are not needed anymore.





--


Regards,


Peo Sjoblom

"Michael" wrote in message
...
Hi Folks - I have a date in the following format: 2008-09-24. Is there a
way to convert this to text so it displays as 2008-09-24? Thanks.

Michael