Thanks @jyothsnareddy4336 Check out my other best practices videos as well. Task Management Best Practices - ua-cam.com/video/DJcxPtu-rcg/v-deo.html Efficient Tasks Management using the New Planner 2024 - ua-cam.com/video/kgxqzDirw1o/v-deo.html Microsoft Teams Meetings - 16 Best Practices - ua-cam.com/video/l3Bvq-I0hy4/v-deo.html Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html OneDrive Best Practices Part 1 - ua-cam.com/video/D7ZrfphW4vo/v-deo.html Part 2 - ua-cam.com/video/nFx6YQxc-b4/v-deo.html Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html Cheers. Doc.
Thanks @sarabjeetsinghkhanuja7379 Check out my other best practices videos as well. Task Management Best Practices - ua-cam.com/video/DJcxPtu-rcg/v-deo.html Efficient Tasks Management using the New Planner 2024 - ua-cam.com/video/kgxqzDirw1o/v-deo.html Microsoft Teams Meetings - 16 Best Practices - ua-cam.com/video/l3Bvq-I0hy4/v-deo.html Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html OneDrive Best Practices Part 1 - ua-cam.com/video/D7ZrfphW4vo/v-deo.html Part 2 - ua-cam.com/video/nFx6YQxc-b4/v-deo.html Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html Cheers. Doc.
Sir I am still getting error in few dates only like 15-02-2024 And dates like 8-10-2024 get reversed to 10-08-2024 and 03-06 get reversed to 06-03 -2024 format please help
Thanks @mariaemiliac Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html 10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html Cheers. Doc
Thank you so much , Nitin . Spent 4-5 hours just to figure out this via different videos . Finally ,found your guide and within few min it was all sorted .
Thanks @Pandey-pooja Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html 10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html Cheers. Doc
Other videos just give alternatives to set a format but without defining the issue. this video Master them all. much appreciated for the demonstration. I have changed my pc date format then followed the PowerQuery method. it works perfectly.
Thanks @jubran5 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html 10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html Cheers. Doc
I have had this problem for over two days and this just solved it! I have a column of dates in a csv file and it's formatting differently for the 01/1-12 days and 1/13-up days. When I load it to power BI it just wont recognize the 01/13-up dates and returns an error. I tried formatting it from the CSV but somehow it is not taking custom format. I even did text to columns as well as extract function in power just to get it right but even then I am stuck with a dd/mm/yy. I still couldn't make it to a mm/dd/yy format. I just realized I had to change the regional setting in the control panel to resolve this. Anyhow, your method is simple but it solves this date conundrum that I've had easily. Thank you so much! I am so relieved to say the least! More power to your channel! Subscribed!
Thanks @ersofrescht4661 Glad you found this useful. Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html 10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html Cheers. Doc
That's a great guide, thank you. Unfortunately I only need it for about 15 mins of work and I've now got a powershell script to flip my locale settings between DD/MM/YYYY and YYYY-MM-DD. Which is much faster for what I need. I did learn something about Excel though, which is great
Thanks @juliesolace Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html 10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html Cheers. Doc
Sir, thanks for the video, i was pulling the report from one of the application, upon this video i have changed the regional settings in the application then downloaded the report, it calculates as date format... thank you very much, this really helped me
Thanks @hariharagupta5638. You cannot keep changing date format at system level for every import. That is why this method is better. Check out my other best practices videos as well. Efficient Tasks Management - ua-cam.com/video/vLFpWVfUfQ8/v-deo.html Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html Word Tables Best Practices - The ultimate guide - ua-cam.com/video/ueKCHxNUOkA/v-deo.html Cheers. Doc.
Thanks @muhammadassadansari6284 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html 10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html Cheers. Doc
Thanks @balajirajagopal299 The default is based upon Windows Regional Setting. Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html 10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html Cheers. Doc
Thanks @r0260064 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html 10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html Cheers. Doc
Thanks @akshaynitinvaidya Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html 10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html Cheers. Doc
Sir, I have a csv file which I want to update (add more data). Now, if I follow this method, update the data and then convert it back to a csv using the save as--> csv option, will it work? or do I need to change the formatting again?
Hi Dr Nitin, Appreciate your content. Would be great help if you could include a way to convert datetime function as 'yyyy/mm/dd hh:mm:ss' . My only solution thus far is to save as a .CSV file as files will reformat datetime into locale format. Thank you
Dear Chris What is the requirement? Convert from which format to which format? In Power Query, we can use locale based functions, or many other approaches. Please post some input and intended output examples and then I will create the relevant content. Cheers. Doc.
Dr. Nitin, I have an issue where I am exporting very old files from the year 2000 from a paid data repository in excel csv format. The date format in the repository shows as (MM-DD-YY). When I open the csv file, the date format is not entirely intact. Some of the dates are preserved in MM-DD-YY, but most are changed to YYYY-MM-DD. But does this in the worst way, by adding (20) before the month and turning it to a YYYY. For example, a record dated 12-10-01 (Dec, 10, 2001) becomes 2012-10-01 (2012, Oct, 01). The entire year, month and day is wrong. It is really wierd. Then, when I convert the .csi file to Txt, as in your tutorial, the date will appear exactly as it does in the csv file, e.g., in both formats. Its really messed-up. Have you seen anything like this?
This is a year 2000 (Y2K) problem. Read this article - you will find the solution. learn.microsoft.com/en-us/office/troubleshoot/excel/two-digit-year-numbers
Thanks @mikewallace6810 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html 10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html Cheers. Doc
What if it's not a csv but an excel file itself that has dates in different format than my locale. Then when I open it on my Indian locale computer, will it read and store dates correctly? I want it to retain the original format mm/dd/yy and not change it to dd/mm/yy.
Thanks MANI MARAN JAMBAI. Check out my other best practices videos as well. Efficient Tasks Management - ua-cam.com/video/vLFpWVfUfQ8/v-deo.html Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html Word Tables Best Practices - The ultimate guide - ua-cam.com/video/ueKCHxNUOkA/v-deo.html Cheers. Doc.
Thanks @sreenivasrao9805 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html 10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html Cheers. Doc
Sir just wanted to know in CSV there is new line automatically coming when i clone the csv from git how to avoid automatic new line for eg Failed Data Validation FileName cannot be Empty this data will turn to Failed Data Validation FileName cannot be Empty
Sir , I am facing issue when dowloading excel csv.CSV changes to wrong dates upon save. for ex : when I enter 12-Oct-1945 , saving in 12-oct-45 format. when I tried to read that cell value it is showing as 12-oct-2045.could you please help with solution
By default, Excel takes the cutoff year as 29. Below that it will be 20xx after that it will be 19xx. To change the cutoff date, to go control panel - regional settings - Date - cutoff date.
@@efficiency365 Thank you for your response . But sir , is there any way to change the cut off date using angular typescript . End users who is using application not aware of system settings . If there is any solution that is actually a saviour .
Thanks for your feedback. Do explore my blog at efficiency365.com/blog Check out my My Udemy courses Excel to Power BI s.efficiency365.com/upbi Pivot Tables s.efficiency365.com/upt Learn 130 powerful efficiency best practices across Office 365 - read my latest book - s.efficiency365.com/bk Also let me know if you would like me to cover any topics relevant to you. Cheers. Dr Nitin (doc) Paranjape.
Thanks @ianku5208. Check out my other best practices videos as well. Efficient Tasks Management - ua-cam.com/video/vLFpWVfUfQ8/v-deo.html Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html Word Tables Best Practices - The ultimate guide - ua-cam.com/video/ueKCHxNUOkA/v-deo.html Cheers. Doc.
Thank you Dr. Nitin! Your way of explanation is wonderful. This solution saves many
Thanks @jyothsnareddy4336
Check out my other best practices videos as well.
Task Management Best Practices - ua-cam.com/video/DJcxPtu-rcg/v-deo.html
Efficient Tasks Management using the New Planner 2024 - ua-cam.com/video/kgxqzDirw1o/v-deo.html
Microsoft Teams Meetings - 16 Best Practices - ua-cam.com/video/l3Bvq-I0hy4/v-deo.html
Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html
OneDrive Best Practices Part 1 - ua-cam.com/video/D7ZrfphW4vo/v-deo.html Part 2 - ua-cam.com/video/nFx6YQxc-b4/v-deo.html
Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html
Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html
OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html
Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html
Cheers. Doc.
Wasted 2 hours working out the solution until I found this Video, thanks a ton!! Solved in less than a min
Thanks @sarabjeetsinghkhanuja7379
Check out my other best practices videos as well.
Task Management Best Practices - ua-cam.com/video/DJcxPtu-rcg/v-deo.html
Efficient Tasks Management using the New Planner 2024 - ua-cam.com/video/kgxqzDirw1o/v-deo.html
Microsoft Teams Meetings - 16 Best Practices - ua-cam.com/video/l3Bvq-I0hy4/v-deo.html
Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html
OneDrive Best Practices Part 1 - ua-cam.com/video/D7ZrfphW4vo/v-deo.html Part 2 - ua-cam.com/video/nFx6YQxc-b4/v-deo.html
Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html
Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html
OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html
Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html
Cheers. Doc.
Sir I am still getting error in few dates only like 15-02-2024
And dates like 8-10-2024 get reversed to 10-08-2024 and 03-06 get reversed to 06-03 -2024 format please help
Thank you Dr. Nitin! This explanation was very enlightening and clear! It served me a lot!
Thanks @mariaemiliac
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc
Thank you so much , Nitin . Spent 4-5 hours just to figure out this via different videos . Finally ,found your guide and within few min it was all sorted .
Thanks @Pandey-pooja
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc
Other videos just give alternatives to set a format but without defining the issue. this video Master them all. much appreciated for the demonstration. I have changed my pc date format then followed the PowerQuery method. it works perfectly.
Thanks @jubran5
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc
I have had this problem for over two days and this just solved it! I have a column of dates in a csv file and it's formatting differently for the 01/1-12 days and 1/13-up days. When I load it to power BI it just wont recognize the 01/13-up dates and returns an error. I tried formatting it from the CSV but somehow it is not taking custom format. I even did text to columns as well as extract function in power just to get it right but even then I am stuck with a dd/mm/yy. I still couldn't make it to a mm/dd/yy format. I just realized I had to change the regional setting in the control panel to resolve this. Anyhow, your method is simple but it solves this date conundrum that I've had easily. Thank you so much! I am so relieved to say the least! More power to your channel! Subscribed!
Thanks @ersofrescht4661
Glad you found this useful.
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc
That's a great guide, thank you.
Unfortunately I only need it for about 15 mins of work and I've now got a powershell script to flip my locale settings between DD/MM/YYYY and YYYY-MM-DD. Which is much faster for what I need.
I did learn something about Excel though, which is great
The key thing to learn is to use Power Query for all data clean-up needs. Scripts are great but why write code when you can do it out-of-the-box?
Thank you so much sir. I can't believe I spent more than 3 hours just trying to fix this date problem, glad I finally conquered it. Pheew.
Thanks @juliesolace
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc
Sir, thanks for the video, i was pulling the report from one of the application, upon this video i have changed the regional settings in the application then downloaded the report, it calculates as date format... thank you very much, this really helped me
Thanks @hariharagupta5638.
You cannot keep changing date format at system level for every import.
That is why this method is better.
Check out my other best practices videos as well.
Efficient Tasks Management - ua-cam.com/video/vLFpWVfUfQ8/v-deo.html
Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html
Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html
Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html
OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html
Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html
Word Tables Best Practices - The ultimate guide - ua-cam.com/video/ueKCHxNUOkA/v-deo.html
Cheers. Doc.
Thanks for the video Sir. Gold for you!
Thanks @muhammadassadansari6284
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc
Appreciate the directions. Was one issue that was causing me nightmares in my data analysis. Is there a way to set the Locale permanently.
Thanks @balajirajagopal299
The default is based upon Windows Regional Setting.
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc
Thank you so much! This has been bothering me for so long, now I finally know the solution!
Thanks @r0260064
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc
This was very useful! thanks
Thanks @akshaynitinvaidya
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc
Sir, I have a csv file which I want to update (add more data). Now, if I follow this method, update the data and then convert it back to a csv using the save as--> csv option, will it work? or do I need to change the formatting again?
It will work. But after saving the target application needs to recheck data types.
Hi Dr Nitin,
Appreciate your content. Would be great help if you could include a way to convert datetime function as 'yyyy/mm/dd hh:mm:ss' . My only solution thus far is to save as a .CSV file as files will reformat datetime into locale format.
Thank you
Dear Chris
What is the requirement?
Convert from which format to which format?
In Power Query, we can use locale based functions, or many other approaches.
Please post some input and intended output examples and then I will create the relevant content.
Cheers.
Doc.
Dr. Nitin,
I have an issue where I am exporting very old files from the year 2000 from a paid data repository in excel csv format. The date format in the repository shows as (MM-DD-YY). When I open the csv file, the date format is not entirely intact. Some of the dates are preserved in MM-DD-YY, but most are changed to YYYY-MM-DD. But does this in the worst way, by adding (20) before the month and turning it to a YYYY. For example, a record dated 12-10-01 (Dec, 10, 2001) becomes 2012-10-01 (2012, Oct, 01). The entire year, month and day is wrong. It is really wierd. Then, when I convert the .csi file to Txt, as in your tutorial, the date will appear exactly as it does in the csv file, e.g., in both formats. Its really messed-up. Have you seen anything like this?
This is a year 2000 (Y2K) problem.
Read this article - you will find the solution.
learn.microsoft.com/en-us/office/troubleshoot/excel/two-digit-year-numbers
Awesome content. Thanks!
Thanks @mikewallace6810
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc
What if it's not a csv but an excel file itself that has dates in different format than my locale. Then when I open it on my Indian locale computer, will it read and store dates correctly? I want it to retain the original format mm/dd/yy and not change it to dd/mm/yy.
Always use Power Query for import. Then you can use From Locale option on a per column basis.
Superb explanation.!
Thanks MANI MARAN JAMBAI.
Check out my other best practices videos as well.
Efficient Tasks Management - ua-cam.com/video/vLFpWVfUfQ8/v-deo.html
Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html
Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html
Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html
OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html
Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html
Word Tables Best Practices - The ultimate guide - ua-cam.com/video/ueKCHxNUOkA/v-deo.html
Cheers. Doc.
thank you! it helped me a lot :)
Thanks @sreenivasrao9805
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc
Sir just wanted to know in CSV there is new line automatically coming when i clone the csv from git how to avoid automatic new line for eg Failed
Data Validation
FileName cannot be Empty this data will turn to Failed
Data Validation
FileName cannot be Empty
Here is how :
docs.github.com/en/get-started/getting-started-with-git/configuring-git-to-handle-line-endings
Sir ,
I am facing issue when dowloading excel csv.CSV changes to wrong dates upon save. for ex : when I enter 12-Oct-1945 , saving in 12-oct-45 format. when I tried to read that cell value it is showing as 12-oct-2045.could you please help with solution
By default, Excel takes the cutoff year as 29. Below that it will be 20xx after that it will be 19xx.
To change the cutoff date, to go control panel - regional settings - Date - cutoff date.
@@efficiency365 Thank you for your response . But sir , is there any way to change the cut off date using angular typescript . End users who is using application not aware of system settings .
If there is any solution that is actually a saviour .
Use Power Query to import data. There you can put your own logic easily.
I already tried both methods but didnt work. How to resolve this problem?
What is the exact problem?
Super nice explained SIR
Thanks
Very usefull video sir...
Thanks for your feedback.
Do explore my blog at efficiency365.com/blog
Check out my My Udemy courses
Excel to Power BI s.efficiency365.com/upbi
Pivot Tables s.efficiency365.com/upt
Learn 130 powerful efficiency best practices across Office 365 - read my latest book - s.efficiency365.com/bk
Also let me know if you would like me to cover any topics relevant to you.
Cheers. Dr Nitin (doc) Paranjape.
@@efficiency365 sir kindly can you explain power pivot basic to pro concept... 👍
Thank u
Thanks @ianku5208.
Check out my other best practices videos as well.
Efficient Tasks Management - ua-cam.com/video/vLFpWVfUfQ8/v-deo.html
Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html
Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html
Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html
OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html
Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html
Word Tables Best Practices - The ultimate guide - ua-cam.com/video/ueKCHxNUOkA/v-deo.html
Cheers. Doc.