Get instant live expert help on date format in excel formula
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have a column with the mixed 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
FILTER formula experiencing error because of non-standardisation of date format
Solved by M. H. in 27 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, if I paste a data 04/12/2018, it recognizes as December 4th. Please help!
Solved by G. J. in 13 mins
My Excel keeps crashing. Then my secondary problem is a incompatible 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