hi
with the date in b2 and wanting to move it to e3 as text, something like
this might work.....
sub changetotext()
Range("E3").Formula = "=Text(B2, ""mm/dd/yyyy"")"
Range("E3").Copy
Range("E3").PasteSpecial xlPasteValues
end sub
this way it would work of a button.

regards
FSt1

" wrote:

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