Convert Date to Text

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

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
 
=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
 
Back
Top