Excel - Enter Numbers in Millionths - Episode 1817

Microsoft Excel Tutorial: Entering Numbers in Millionths Made Easy in Excel | Excel Tips and Tricks.

Welcome to another episode of the MrExcel podcast. In this episode, we will be discussing a handy trick for quickly entering numbers in millionths in Excel. This is a common frustration for many Excel users, as miscounting the zeros can lead to incorrect calculations. But fear not, we have a solution for you!

During a conversation with Jim from Timken, he shared with me his job of measuring tolerances and the need to enter numbers in millions, such as 12-millionth or .000012. Jim discovered a hidden feature in Excel that automatically inserts a decimal point, making the process much easier. To access this feature, go to File, then Options, and under Advanced, you will find the option to automatically insert a decimal point. You can even control the number of decimal places, up to six.

This feature may seem familiar to those who have used an old adding machine, where entering 1234 would result in $12.34. However, Jim has found a clever use for it by setting it to six decimal places. Now, all he has to do is enter 12, followed by the six digits, and Excel will insert the correct number of decimal places every time. But here's the interesting part - this feature can also be used for negative numbers. For example, if you need to enter numbers in thousands, you can simply enter 12 and it will become 12,000.

This feature is not only useful for entering tolerances in millionths, but also for anyone who needs to enter data in thousands, millionths, or even billionths. It saves you from having to enter all those extra zeros, making your work much more efficient. So, a big thank you to Jim for sharing this tip with us. And thank you for tuning in to this episode of the MrExcel podcast. Don't forget to subscribe for more helpful Excel tips and tricks. See you next time!

Buy Bill Jelen's latest Excel book: www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Entering Millionths in Excel
(00:12) Discussion of Excel Tricks with Guest Jim from Timken
(00:23) Hidden Feature to Automatically Insert Decimal Point
(00:33) Importance of Accurate Decimal Placement
(00:43) Feature Location and Customization
(01:01) Similarity to Old Adding Machines
(01:12) Demonstration of Feature in Action
(01:27) Possibility of Negative Numbers for Different Units
(01:53) Versatility of Feature for Various Data Entry Needs
(02:09) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial

This video answers these common search terms:
Automatically insert decimal point in Excel
Controlling decimal places in Excel
Entering data in thousands or millionths or billionths in Excel
Entering tolerances in millionths
Excel adding machine feature
Excel data entry shortcuts
Excel decimal formatting
Excel tips and tricks
Excel tricks
Using negative numbers to move decimal places in Excel

Join the MrExcel Message Board discussion about this video at www.mrexcel.com/board/threads/1153638/



Jim from Timken shares a trick to prevent typing extra zeroes, even if you are entering 0.000012. This trick works for entering numbers in thousands, millions, thousandths, millionths or any order of magnitude.