Need help for Change day to month and month to day

[ahaque]

Dear all
I need one help, I collect some data by CSV file which i save as xlsx, I found one big miss match on date field. Like 12the may 2011 but its showing 5th December 2011. please help anyone have any solution.
NOTE: I not advance user, basic user of excel.

BR_No Sec Ticket Arival_time WT Close_time
001 0 1 12/05/2011 13:15 1:30 12/05/2011 13:18
012 1 1 08/05/2011 10:00 10:15 08/05/2011 10:28

thanks in advance

-- removed inline image ---

 

[Marcelo Branco]

Hi,

Welcome to the forum

What is your regional setting for dates - mm/dd/yyyy?

M.

 

[cgcamal]

Hi ahaque,

You can try to force the date format of the respective column where are the dates located.

You can do Right click on the column or cell you want, then go to "Cells Format", then select
"Custom" and say to Excel to show the dates with this format:

dd/mm/yyyy -->if you want day/month/year

or

mm/dd/yyyy -->if you want month/day/year

Hope it helps.

Regards

 

[Scott Huish]

Have you tried formatting this column as mm/dd/yyyy?

 

[ahaque]

Hi,

Welcome to the forum

What is your regional setting for dates - mm/dd/yyyy?

M.

Thanx
My current Setting is dd/mm/yyyy

 

[ahaque]

Thanks for you advice,

But my problem is not for changing date format......
Problem is : i have 9 column data from their 3 column data for Date with Time, Some of that date is showing 5th December 2011(05/12/2011 hh:mm) where as original date is 12th may 2011 hh:mm.
So how can i solve the problem if you can help i will thankful to you.....

 

[ahaque]

Hi ahaque,

You can try to force the date format of the respective column where are the dates located.

You can do Right click on the column or cell you want, then go to "Cells Format", then select
"Custom" and say to Excel to show the dates with this format:

dd/mm/yyyy -->if you want day/month/year

or

mm/dd/yyyy -->if you want month/day/year

Hope it helps.

Regards

Please i upload the sample file and link is below :
http://www.mediafire.com/?9ud9mcq8zygfwec

 

[Marcelo Branco]

Thanx
My current Setting is dd/mm/yyyy

If you can separate Date and Time in two different columns try

Select the dates you need to correct
Data>Text to Columns
pick Fixed Width
Next
Normally the Date (in the small window below) column is selected by Excel, then click in Date and change to MDA
Finish

done!

HTH

M.

 

[ahaque]

Please i upload the sample file and link is below :


http://www.mediafire.com/?9ud9mcq8zygfwec

or
http://www.mediafire.com/file/9ud9mcq8zygfwec/export_All_BR_258.rar
[this is one of the RAW file for one branch only where problem available]

http://www.mediafire.com/file/rmb9omdqrucmd9e/Ladies Section_Final.xlsx
[This is one of the complete file where this date problem available]

Please Hlp

 

[Marcelo Branco]

I downloaded the file. How do you know which dates are wrong?

M.