S sylink Aug 13, 2014 #1 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
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
C Claus Busch Aug 13, 2014 #2 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 Click to expand... select your data => Format cells => and change the format to dd/MM/yyyy Regards Claus B.
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 Click to expand... select your data => Format cells => and change the format to dd/MM/yyyy Regards Claus B.
S sylink Aug 14, 2014 #3 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 Click to expand... 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
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 Click to expand... 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
