Get instant live expert help on I need help with excel change date format

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi this is Mounika, When I connect my excel sheet to an external Data Source(SQL SERVER), I couldn't get the correct date format. Even though I change the format of that column to short date I still showing as text. Is there a way to change the excel date format when I connect to external data source?
Solved by A. F. in 30 mins
i already change the excel date format, but it didn't change, why? what is wrong?
Solved by D. S. in 21 mins
I require a formula to change the following text into date format: 20180102
Solved by I. C. in 19 mins
i want to change text data in this format ~40464% to date, please help
Solved by Z. U. in 12 mins
When I enter a date in the format 02-02, my Excel 2013 sets the date to 02-Feb. I need it to display Day-Month-Year in the format 01-01-****, can someone tell me how to change it so it will display this date all the time on all worksheets?
Solved by D. F. in 25 mins