Last Updated on August 14, 2016 by Dave Farquhar
At work part of my job is reporting security metrics along with my colleague, and sometimes we report things like the number of machines running a specific operating system. The problem we run into is that when it comes to operating system versions, OS X versions 10.1 and 10.10 are really not the same. We run into similar issues with versioning for other operating systems too, such as AIX.
To keep Excel from dropping those significant zeroes on your charts, highlight the column containing your version data and switch it from a numeric format to text format. Then switch to the tab that contains your chart, refresh the data, and your charts will show the zeroes properly.
David Farquhar is a computer security professional, entrepreneur, and author. He started his career as a part-time computer technician in 1994, worked his way up to system administrator by 1997, and has specialized in vulnerability management since 2013. He invests in real estate on the side and his hobbies include O gauge trains, baseball cards, and retro computers and video games. A University of Missouri graduate, he holds CISSP and Security+ certifications. He lives in St. Louis with his family.
One thought on “How to keep Excel from dropping zeroes after the decimal point”
In QuatroPro: Select Format/Section Properties/Number/Decimal Places.
In Excell (2013): Select Number (Ribbon defaults to General)/bottom right pull down, select number of decimal places.
Both will force 2 spaces beyond the decimal (or however many you specify).
Comments are closed.