Hi All,

Date in cell's default as mm/d/yyyy and I know you can change the format to what ever you want (ex yyyy-mm-dd) but how to you get that format to equal in VBA

range("A1").value to equal yyyy-mm-dd instead of the default

Result:
11/1/2010 to 2010-11-01