changing August 31, 2007 into 31.08.2007

  • Thread starter Thread starter ziom
  • Start date Start date
Z

ziom

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
 
Data > Text To Columns > Delimited: Next > Next > Date: MDY
Then set number format to dd.mm.yyyy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move Worksheet to other File 1
Changing all Dates on Headers 4
Trailing 3 month sales 9
Counting on two separate values 5
Dates - Need to display date one month prior to user-entered date 13
Days360 error between July & August 2008 4
Change date format for existing sheet? (XL2K+XL2003) 6
Conditional formatting on a dynamic range - workaround 1

Back
Top