Solved: Date format

[Klartigue]

Is there a macro code or formula that can format 5/14/2012 into yyyy-mm-dd? I have dates located in column H, starting in cell H2, and I would like all the dates to be formatted like yyyy-mm-dd?

Thanks!!

[Paul_Hossler]

Did you try a custom number format of yyyy-mm-dd?

In VBA it'd be something like Columns("H:H").NUmberFormat = "yyyy-mm-dd"

Paul

[Klartigue]

that VBA code works great, thanks!