Find and Replace formatting - on dates - Advanced Excel - #shorts
Channel: Efficiency 365 by Dr Nitin
Date: 2022-01-27

Dates should always be in dd-mmm-yy format.
This avoids the confusion about which number is day and which one is month. Here is a powerful way to make sure all dates are in the right format.
Across multiple blocks of data and across multiple sheets.
No select all. No format painter. 
The humble Find - Replace. Amazingly useful and powerful.

This will not work if the cells have other formatting like color / borders.
Another video for that :)



Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

https://s.efficiency365.com/bk

Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms

Udemy Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://hi.switchy.io/22B1
Excel to Power BI - https://swiy.io/pivotsh

Learn more from 1000+ blog articles by Dr Nitin Paranjape 
https://efficiency365.com/blog

LinkedIn : https://www.linkedin.com/in/nitinparanjape/
Twitter : https://twitter.com/drnitinp

Created using Camtasia: https://www.techsmith.com/video-editor