How to keep Excel from dropping zeroes after the decimal point

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.

If you found this post informative or helpful, please share it!

One thought on “How to keep Excel from dropping zeroes after the decimal point

  • May 20, 2015 at 9:28 pm
    Permalink

    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.