Get instant live expert help on date format in excel

“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

I have a column with the mixed excel date format. Some of them are in date format and some are in general format. I need everything to be in date format.
Solved by O. Y. in 15 mins
My Excel keeps crashing. Then my secondary problem is a incompatible excel date format..
Solved by I. H. in 20 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
I'm copying date format 04/27/2018 and pasting in excel, however it does not recognize it as April 27, I did format date format to English (United States) but still not resolved the issue, now I want to change it to military date format. if I paste a data 04/12/2018, it recognizes as December 4th. Please help!
Solved by G. J. in 13 mins
In cell C10, enter a database function to display the date of the apartment that had the oldest remodel date based on the filtered data. Format the result with Short Date format.
Solved by X. W. in 28 mins