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