changing August 31, 2007 into 31.08.2007

changing August 31, 2007 into 31.08.2007

Post by ziom » Sat, 15 Sep 2007 18:26:58


I'm struggling with changing the date in cell like August 31, 2007
into 31.08.2007, and the range Aug 1, 2007 - Aug 31, 2007 into a
european format date.
I haven't found any good solution yet, so please give me a hand in
stugglin...

thank you up front.
Marius
 
 
 

changing August 31, 2007 into 31.08.2007

Post by R2FyeScncy » Sat, 15 Sep 2007 19:18:02

Format > Cells... > Custom > dd.mm.yyyy
--
Gary''s Student - gsnu200744

 
 
 

changing August 31, 2007 into 31.08.2007

Post by ziom » Sat, 15 Sep 2007 19:21:26

:D no .. it doesn't work
 
 
 

changing August 31, 2007 into 31.08.2007

Post by TG9ya » Sat, 15 Sep 2007 20:12:02

Data > Text To Columns > Delimited: Next > Next > Date: MDY
Then set number format to dd.mm.yyyy
 
 
 

changing August 31, 2007 into 31.08.2007

Post by ziom » Tue, 18 Sep 2007 14:44:13


I got Excel 2003 and it doesn't work at mine. :(