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

“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 want to extract from a date the year and month to be in the format yearly-monthly as a number/date not text
Solved by O. D. in 23 mins
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 date format when I connect to external data source?
Solved by A. F. in 30 mins
I need help with a formula to combine 3 cells, display the date as date format and add sequential number at the end. This is what I came up with... =(E2&""&C2&""&D2),(TEXT(C2,"ddmmmyyyy")),(TEXT(ROW(C2),"0")
Solved by B. U. in 23 mins
I've got a column of date and times displayed as '12/14/18 19:01' but unfortunately they're in the general format so seen as text. I want to convert these to be in date format so I can use them in formulas but I've tried many methods of doing so (such as =datevalue, changing the format etc) but I keep getting the VALUE! error. Please help if you can.
Solved by S. Q. in 26 mins
I require a formula to change the following text into date format: 20180102
Solved by I. C. in 19 mins