Excel Date format in MM/DD/YYYY. How to change it? - Macrolix Weekly Digest

[Arun N]

Greetings,

Hope you are doing well. Below is our weekly digest of articles we posted recently. Hope you find it useful. Thanks.

Date Format in MM/DD/YYYY

Many times we find that the date in Excel is in MM/DD/YYYY even when we type in DD/MM/YYYY format. It was one of the most annoying things I went through while learning Excel. In the below article (link), we have provided a simple and permanent solution for it. We have started a new series 'Dating with Excel Dates' where we will be providing solutions to all date issues and help you use dates like a champ in Excel.

Article Link: https://blog.macrolix.in/2020/12/dates-in-mmddyyy-format.html

Google Drive Direct Download Link

Google Drive is a fantastic app provided by Google to store and share our files. While sharing the file link from Google Drive, by default, when a user clicks it, it takes them to the file and they have to press the 'Download' button to download it. Wouldn't be nice if we can provide a link and the file gets downloaded as they click it? Click the below article link and learn how.

Article Link:https://blog.macrolix.in/2020/11/google-drive-direct-download-link.html

Hope to get you more interesting articles for the next week. Have a great week ahead. Send #1 (with #) to +91 94456 20048 in WhatsApp to get weekly updates in WhatsApp (ignore if already done).

Best Regards,

Arun N

Website | Blog | +91 9445620048