Excel Date Format Won't Change | I Can't Change Excel Date Format!
Тәжірибелік нұсқаулар және стиль
Download the featured file: www.bluepecantraining.com/exc...
In this video I explore a problem with dates and times, where Excel will not allow you to change the date/time format. This problem is caused by the dates and times being entered as text values.
The solution is to use Text to Columns to convert the dates and times to numeric values. You will then be able to apply date and time formats in the normal way.
Need pre-built Excel spreadsheet solutions? Try Simple Sheets - over 100 templates covering your personal and work-based needs including Gantt charts, personal budgets, employee scheduling, timesheets and more… www.simplesheets.co/a/45451/v...
By clicking on this link you are helping to support this blog - thanks!
------------------------
Пікірлер: 216
... annnnnd just like that, I'm not going to throw my computer out the window! Thank you for fixing my whole day!
Been trying to find a fix for this for...admittedly...a lot longer than I should have. You fixed my problem so quickly and efficiently! Thank you.
Mehnnnn just 2 minutes into the video and i got the solution to what gave me sleepless nights, i just got an internship and i have one month to finish up 8 projects, this challenge kept me on one spot for days, the frustration was watching many videos on here with the problem remaining the same. This was it for me.. Thank you big time Sir. I love youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu. From Nigeria
Outstanding! I searched over an hour on what to do when you can't change the date format. I found your video and you explained it within the first four minutes. Thank you so much!!!
Finally! This is the only video that helped me understand the problem and SOLVE IT!!! Thank you! Brief and effective! Thank you, thank you, thank you!
You're my hero! I imported data and couldn't change my date format in Excel! This was a complete life saver for a big presentation!
Wow thanks! We literally had a problem with this today! Our data stream changed from UK date format to US date format halfway through for no reason, and nothing we did would allow the format to change. Your solution worked!
Absolutely brilliant - 2 mins in and you had changed my mood from frustration to wonder!!! Problem solved. THANK YOU!!!
Just another super clear, eazy and fast explanation!
Oh man! You just saved me a TON of time, thinking I had to re-enter thousands of data fields with incorrect date formatting. THANK YOU !!!!!! : )
Excellent practical application of Text in columns. Thank you for these tips Chester!
Sir, thank you so much for posting this. I have been struggling with the date formats for years now. Spent countless hours cleaning those one by one.
You're an absolute superstar for making this video. Super helpful and easy to follow!
Short and sweet, thank you very much!! All the other tutorials were just saying to go to format text haha. Cheers, delimited worked perfectly
love this tutorial! helping me alot for my final year project-ive got data from 2004-2020 and they're all on different formatting LOL imagine how frustrating it was for me. Thank you so much!
You sir. Just saved my life at work. Was getting real flustered when the sort didnt work cause they had inconsistent date "datas".
THANK YOU! I have been trying to solve this problem for years thank you very much for the solution! I discovered some of the dates on my sheet were listed as "text", I copied the column, pasted it as Value 123 and applied your solution.😉
That's the way a tutorial should be. Direct to the point, short and problem solving. TNX Mr Chester.
I can't thank you enough! I've spent a long time trying to change the date and format the correct way to sort my worksheet
Thank you, this saved me a lot of time manually correcting dates that would not convert into numbers or work on formulas as they were recognised as text with a time at the end after the date. The text to columns option as delimited file and separator as space allowed me to separate the time from the date and next choose the right date format option for the problematic dates. Thanks again.
thank you, been racking my brain trying to figure this out myself. concise and to the point, instantly liked the video.
Thank you SO MUCH!! I love excel and I know more about it than nearly everyone in my department, so when I have an issue that stumps me, I feel like an idiot. You redeemed me!!
Thank you!!! I have been struggling with this for along time and finally found your video and it was very clear on how to fix!!
Un genio. Gracias!!!!!! I had written a lot of dates thinking in Spanish format, but it was in English Format!, thanks to your explanation I didn't have to rewrite all of them to reformat :)
Thank you so very much for this video. I wish if I could find your video 2 days ago, so I didn't have to waste my 2 days for solving this problem...Thanks again!!!!!
Tried all possible ways even the best worst Microsoft Support.. At last You have made it..Thanks a lot
U've saved my days, brilliant quick tips in just under 3 minutes. Thank U very2 much
Omg thank you so much 😭😭 I’ve been looking for a fix too long but this was just straight to the point and totally erased my frustration 😂
Awesome quick little tutorial, Thanks Chester.
Just saw 2 min of this video and my problem is solved. After seeing multiple videos this only worked perfectly !
Your video simply made my day better! This is absolutely amazing!
Looking for this solution from long time and this one works like magic
This prevented me from having a full breakdown at work! Thank you for your service!
Straight to the point…. thank you!!!
Life saver ! I've struggled so hard with this forever
thx so much! I have been trying and was not getting anywhere until i saw your video. Thx again for your helpful tutorial!
Precisely what I needed. Thank you.
GREAT video! Clear, easy to understand. Concisely delivered information. Thank you
This has saved me a lot of time - thank you so much.
you really dig it deep to the problem and see it through why people need to search, not just like the others^^🤩🤩
This is excellent. You've just earned a subscriber! Thank you
Thank you!!! was such a frustrating problem til I saw your video!
Thanks for the search algorithm who brought me here! Thanks for the solution!
Finally one correct video
I am very glad that you make this video. Otherwise, I will not know how to change it.
Brillant explanation.. my pivot now recognises date format!!!! Subscribed
Exactly what i was looking for. Thank you!
it helps my class btw, I try it and share what I got from this problems, thanks! very efficient
This was super helpful. Thank you sooo much!
HUGE help! So relieved to get that format changed to a date, thank you! Although, know when I take that newly formatted data and try to plot it on a graph it plots it as a number up to 5000??? How do I put it into a graph now that it's formatted as a date????
This saved me hours of time. Thank you!
I only got to 1:50 and you solved my problem - Thanks!
millon gracias!!! no sé ingles , pero aun así pude solucionarlo con su método . muchas gracias
Thank you,, Very precise and spot-on
Thank you! this was just what I was looking for!
Thank you so much! I was stuck for a quite a bit.
Saved me too. Was going crazy trying to fix a date issue! Thank you!
Perfect it worked. Really spot on video that doesn't waste time.
this worked wonders, thanks for this guide. I noticed that some cells don't follow the format and stay the same.
The only solution that worked. Thanks!
Thank you. I appreciate the help.
Brilliant! Problem solved! Take your flowers 🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉
Thanks so much! This saved me a lot of time
Super thanks for your help !! I love the way how to present your video so bad !! 😍😍
You just saved my day! Thank heaps Chester
You saved me so much time ! Thank you
Thank you so much for this, it was driving me nuts.
thank you, your video fixed my value error so fast!
Thank you so much it saved me a lot of time. 👍
thank you very much, never realized text to columns have that kind of features
Thank you. So easy training
A plus helpful! Thank you!
This definitely works mate. Thanks a lot
Simply Fantastic
You are a lifesaver!!
awesome saved me so much time, thank you
Woww.. pintarnta bapak ini, LIKE 👍
Thanks a lot man it really helped in while I was in a clinch
Thank you so much for your valuable video. !!
Perfectly solved my issue, thank you!
Thanks for the video. I have a one question for you. My pivot chart legend changes colour when I refresh it. Is there a way to stop it? Thanks
Thank you so much for helping me figure this out, I was getting so frustrated lol
Thanks from Armenia a lot!!!
Thank you, this helped me a lot
Problem Solved before the vid was over! Thanks!!!!
Thanks for your help!!
Thank you so much for your help, it was driving me crazy and I couldn't figure out how to fix it.
A video that's actually helpful!
it was driving me crazy; Thanks for you ; helped me ! really appreciate it
Thank you very much. Helped me to fix this error.
Excellent. Many thanks.
Thanks. Short and clear. Boom
Thank you Sir it was very useful tip for me.
Very easy to understand. Excellent. Thanks a lot. With eregards
Thank you so much!
perfect!! thanks Chester
Thank you sir!
Top stuff, thank you Sir!
Thank you so much Sir.
the fact that i even have to look this up on youtube is infuriating EDIT: Also, I see that I didn't thank you for uploading this. Sorry about that; this video helped out a lot. Thanks for the video!