Excel Hack: Number formatting and STOP Merging Cells
Wyn Hopkins
Solving data challenges for companies and people. Power BI | Excel | Fabric | Solver Budgeting & Consolidation. Part of the Amazing team at Access Analytic Microsoft MVP ??6 Million+ YouTube views
This 5 minute video will save you hours over the coming years.
How to set your own number formatting and assign it the comma icon on the Excel Ribbon
How to avoid using Merge Cells
How to save your number formatting as a default each time you open Excel
Important Note
*******
You can Use Ctrl N to start new worksheets that use book.xltx
Also you can turn off your start up screen via File : Options : General and down the bottom of the list remove the tick from the option "Show the Start Screen when this application starts" which will also force the use of book.xltx when Excel starts
********
Subscribe to our YouTube Channel
Connect with me on
LinkedIn https://www.dhirubhai.net/in/wynhopkins/
Twitter https://twitter.com/wynhopkins
Follow our blog here... https://accessanalytic.com.au/blog/
Check out our training
https://accessanalytic.com.au/training
Wyn
..
3 年Thanks Wyn. Save me a lot of time.
Big4 Alumnus | Senior Finance Professional | Renewables | Wind Energy
3 年Concise and Efficient ??
CA Pakistan | MBA (IBA) | Financial Controller
3 年simple and useful tips
Financier
3 年I have seen estimates of how much time has been wasted over the decades by Excel users wanting a simple comma and two decimal places instead of what's called accounting. Add to that the fiddling with psychosis-inducing merge and it turns out Microsoft has cost us all an accumulated 250 million years!
Enthusiastic business and finance analyst with acute problem solving and analytical skills
3 年Love this