If you want to convert the date to text, use the TEXT function.
=TEXT(A2,"yyyy-mm-dd")
--
David Biddulph

"
m wrote in message
...
I have a certain cell that is used to input a date. I want to be able to
push a button and copy this date to antoher cell, however I need the
formatting to change from the original date format to a text format that
goes
yyyy-mm-dd. I've tried using a custom format and then changing that to
text
but the date just changes to a number. Any suggestions?

Thanks

Adam Bush