Automatically convert Date format M/D/YYYY TO DD/MM/YY

**satputenandkumar0** · 11-26-2012, 07:12 AM

Hi Forum,

I am downloading excel worksheet from our companies website in this file date coloumn comes as m/d/yyyy. I want formula to change it automatically to DD/MM/YY.

Thanx

**:) Sixthsense :)** · 11-26-2012, 07:14 AM

What happens if you format the date as dd/mmm/yy? Is it showing the 3 digit month for all the data without any error?

**satputenandkumar0** · 11-26-2012, 07:22 AM

thanx Sixthsense for reply.

it is showing 11/6/2012(mm/dd/yyyy) in cell I want 06/11/2012 (dd/mm/yyyy)

thanx

**:) Sixthsense :)** · 11-26-2012, 07:25 AM

The above one is not the expected reply for my question.... Could you please go though it once again because I have clearly mentioned as 3 digit month.

**satputenandkumar0** · 11-26-2012, 07:31 AM

pls find attached file

**:) Sixthsense :)** · 11-26-2012, 07:45 AM

Please understand the reason for asking the question. The attachment is helpful but still require the answer for the question. Because changing the date setting of your system will be a simple solution for this issue rather than writing a lengthy formula.

**satputenandkumar0** · 11-26-2012, 07:50 AM

let me the solution.

thanx

**:) Sixthsense :)** · 11-26-2012, 07:52 AM

Please don't expect any further support from my end for this thread since not getting valid response.

Hope someone will take care of your issue.

**Pete_UK** · 11-26-2012, 07:56 AM

I don't understand the problem. When I open your file all the dates in column E are in the format dd/mm/yyyy, all with November dates.

Pete

**[email protected]** · 11-26-2012, 08:12 AM

Hi,

Please check if the attached is helpful.

**satputenandkumar0** · 11-26-2012, 08:20 AM

thanx [email protected],

I works perfect.

thank you very much

**satputenandkumar0** · 11-26-2012, 08:26 AM

very big thanx to you

Automatically convert Date format M/D/YYYY TO DD/MM/YY

LinkBack

Thread Tools

Rate This Thread

Display

Automatically convert Date format M/D/YYYY TO DD/MM/YY

Re: Automatically convert Date format M/D/YYYY TO DD/MM/YY

Re: Automatically convert Date format M/D/YYYY TO DD/MM/YY

Re: Automatically convert Date format M/D/YYYY TO DD/MM/YY

Re: Automatically convert Date format M/D/YYYY TO DD/MM/YY

Re: Automatically convert Date format M/D/YYYY TO DD/MM/YY

Re: Automatically convert Date format M/D/YYYY TO DD/MM/YY

Re: Automatically convert Date format M/D/YYYY TO DD/MM/YY

Re: Automatically convert Date format M/D/YYYY TO DD/MM/YY

Re: Automatically convert Date format M/D/YYYY TO DD/MM/YY

Re: Automatically convert Date format M/D/YYYY TO DD/MM/YY

Re: Automatically convert Date format M/D/YYYY TO DD/MM/YY

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions