Date Modification

[sylink]

Please how do convert this using an Excel macro:

06.01.2014 00:00:00
06.07.2014 00:00:00


TO:

06/01/2014
06/07/2014

 

[Claus Busch]

Hi,

Am Wed, 13 Aug 2014 04:02:26 -0700 (PDT) schrieb sylink:

06.01.2014 00:00:00
06.07.2014 00:00:00

TO:

06/01/2014
06/07/2014

select your data => Format cells => and change the format to
dd/MM/yyyy


Regards
Claus B.

 

[sylink]

Hi,



Am Wed, 13 Aug 2014 04:02:26 -0700 (PDT) schrieb sylink:







select your data => Format cells => and change the format to

dd/MM/yyyy





Regards

Claus B.

--

Vista Ultimate / Windows7

Office 2007 Ultimate / 2010 Professional

Thanks for your response. I tried that earlier but it didn''t work. I am using Office 2010. I dont know if there is any other trick