Get instant live expert help on I need help with changing date format in excel
“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 export data from a website in csv format. Date displays as 1.43E+12 and variations of this, it should show as Day, date, month, year.
No matter what i try changing in the format i just receive #####
Solved by T. H. in 15 mins
MAC Computer: Created date shown in Finder and Properties-General on excel files keeps changing as the file is saved. In Properties-Statistics the Created date is correct.
Solved by T. W. in 22 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
The default date format in my version of excel is different than my co-workers and changing all dates with this format to only include half the year. For example, the document when opened on my computer will be "Wednesday, November 21, 18" instead of how it SHOULD be which is "Wednesday, November 21, 2018". I don't have an option with the full year in my formatting for Date options at all. Help!
Solved by C. Q. in 27 mins
WHY DOES MY FORMAT KEEPING REVERTING BACK TO "CUSTOM" WHEN I CHANGE IT TO "GENERAL"? I AM TRYING TO ENTER A NUMBER XX/XXXX, BUT IT KEEPS CHANGING TO A DATE. I HAVE CORRECTED THE FORMAT A DOZEN TIMES!
Solved by K. B. in 23 mins