Automatically changing date format of 09/08/2012 to 2012.09.08

Hello,

Is there a way to do this? Please see topic subject.
Thanks.

by automatic you mean using VBA change() sub?

or

lets assume that b2 contains 09/08/2012

c2 would contain the formula

=year(b2)&"."&month(b2)&"."&day(b2)

Thank you so much. It's now working but the result is 2012.9.8

Is there an additional formula to make ti 2012.09.08?

Thanks!!

yes there is

Please Login or Register  to view this content.

Thank you very much!

you are welcome, mark it as solved