Format a column as date format "yyyy-mm-dd"

Hi all,

I'm trying to modify the following code to convert the date in column B of the "Export" worksheet to a "yyyy-mm-dd" format, but it doesn't work. The solution is probably extremely simple, but I'm still very new to VBA. Can someone help me with this?

Thanks!

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.

Hi Jolivanes,

I tried and it doesn't work - you mean replacing the following correct?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Both worked for me in 2007

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

The top one showed 2013/01/10 in the formatted cell but in the formula bar it shows 1/10/2013

Hmmm am i missing something? It just keeps showing "11/25/2012" for me. I need it to show "2012-11-25"

Okay I think I figured it out - the code originally didn't work because the input wasn't in the right format!

Thanks for your help though!

Glad it has been sorted