changing August 31, 2007 into 31.08.2007
 

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
 

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

changing August 31, 2007 into 31.08.2007
 

:D no .. it doesn't work

changing August 31, 2007 into 31.08.2007
 

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


"ziom" wrote:

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
 

On 14 Wrz, 13:12, Lori wrote:
Data Text To Columns Delimited: Next Next Date: MDY
Then set number format to dd.mm.yyyy

"ziom" wrote:
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

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