Forum Discussion
Microsoft excel date format-not changing at all
Dear Sir,
I am trying to apply text to columns on the New Data Tab of the excel sheet that i have sent- but it is not being converted to dates.
I have used the exact method-: select column of the excel sheet>Data tab on the ribbon>Text to columns>Next>Next>choose YMD>Finish,
I even selected the columns one at a time. The data on the New Data Excel Tab hasn't shown any change. Can you please confirm if something is wrong with the dates on the New Data Tab
It works, please check attached. Hard to say what was wrong in your case.
lotusana003 , I have exactly the same settings. Perhaps you have texts instead of dates.
Take a look at Sergei' second post, second image again.
You must make sure it is MDY
The rows with failed conversions in your exempe files have “days” that are bigger than 12 so I guess you used DMY.Dear Sir,
Could you please send a screen shot of this settings window on your computer. This is the screen shot of the settings on my computer. I don't know whether there is any issue in the settings because of which the date formats are not changing.