Uploaded December 2024 | Updated November 2026, 2 days ago
👩🏻🎓 Check out my new Professional Excel Productivity course
accessanalytic.thinkific.com
Did you know you can now stop Excel from automatically making those annoying changes to your data? Thanks to a a little known update in Excel 365, you can take control of formatting issues like disappearing leading zeros in phone numbers, unwanted date conversions, or long numbers turning into scientific notation. It’s all about one simple tweak in the settings.
This step-by-step guide shows how to disable these automatic changes causing frustration. With this update, typing phone numbers, codes, dates, or long numbers is hassle-free. Make sure you’re using the latest version of Office 365 or Excel 365 to unlock this life-changing feature. Thank you, Excel team, for listening to users and making this possible!
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
wyn.bio.link
👩🏻🎓 Check out my new Professional Excel Productivity course
accessanalytic.thinkific.com
Did you know you can now stop Excel from automatically making those annoying changes to your data? Thanks to a a little known update in Excel 365, you can take control of formatting issues like disappearing leading zeros in phone numbers, unwanted date conversions, or long numbers turning into scientific notation. It’s all about one simple tweak in the settings.
This step-by-step guide shows how to disable these automatic changes causing frustration. With this update, typing phone numbers, codes, dates, or long numbers is hassle-free. Make sure you’re using the latest version of Office 365 or Excel 365 to unlock this life-changing feature. Thank you, Excel team, for listening to users and making this possible!
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
wyn.bio.link










