Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
In this video, you can see how new data conversion settings allow you to turn off automatic formatting for three different scenarios:
1) Leading zeros – Excel automatically removes zeros that are typed before a whole number, but sometimes you may want them there, such as with a New York zip code. With the new settings, you can stop Excel from removing them.
2) Long numbers – When you input a number that is longer than 15 digits, Excel will format the number in scientific notation to shorten it. But sometimes, as in the case of credit card numbers, this is not helpful. Turn off this feature by unchecking a single settings box in Excel Options.
3) Numbers with an E toward the end – If you enter in a part or model number that happens to have the letter E toward the end, Excel thinks you are using scientific notation and automatically converts if for you. This automation can be switched off as well.
If you’d like to read the accompanying blog post for this video on my website, you can access it here: https://www.excelcampus.com/tips/automatic-data-conversion
The Automatic Data Conversion features are currently available for Microsoft 365 subscribers on the Insiders Beta Channel of Excel for Windows (desktop). The feature is flighted, so you might not have it yet even if you are on the beta channel.
You can leave your feedback about these new options in a comment below and I will pass your feedback directly to the Excel team at Microsoft. Or, you can leave feedback directly through the Microsoft portal by going to Feedback on the Help menu in Excel. Be sure to use the hashtag #automaticdataconversions.
Excel Tips & Tricks: https://www.youtube.com/playlist?list=PLKbOx3gUV_E_SoKqIQeMRPZ5HUu3DcYUq
Visit @ExcelCampus for beginner to advanced level Excel tutoring!
0:00 Leading Zeros
4:08 Scientific Notation
6:10 Opening .CSV Files
7:40 Availability
#MsExcel #ExcelCampus