View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Date Modification

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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional