I’ll show you a work around to get number formats in pivot tables to default to whatever number of decimal places you want using the ROUND formula.FREE Shortcuts Cheat Sheet »» http://www.up4excel.co.uk/shortcuts
If you've ever had to mess around with the number format on a pivot table to get rid of random numbers of decimal places then you'll know what a pain that can be. You probably wished there's some kind of default setting that would just do all this for you. Unfortunately there isn't….but there is a workaround, and that is what I'm going to show you how to do in this video today.
ROUND Function
Syntax: =ROUND(number, num_digits)
Examples
=ROUND(12.15, 1) = 12.2
=ROUND(12.15, 0) = 12
=ROUND(12.15, -1) = 10
Before you watch my next video make sure you hit that subscribe button...and get those Excel skills up, and your task times down!!
Here at Up4Excel we’re on a mission to help YOU:
» Get your Excel skills UP and your task time DOWN
» Focus on shortcuts and fast impressive results
» Improve your productivity and free up your time
Everyone will assume you work 24 hours a day to produce the kind of output you’ll be producing in no time…. with the help of Up4Excel training.
Here’s some of the things you could do with the time you’re going to save:
» Invest in yourself, saving even more time with Up4Excel training videos
» Spend more of your time on interpreting rather than compiling reports
» Get ahead of the game and accelerate your next promotion
» Or perhaps leave work on time, or even early, and enjoy your home life
Our videos are packed full of ways to save time and impress those around you. Make sure you subscribe, and hit the bell icon, so you don’t miss out and fall behind!
» 5 Steps to a Bulletproof VLOOKUP
» No More Rounding Errors: MS Excel ROUND Formula
======================================================================================
The Webcam I Use:
Logitech C920 HD Pro Webcam, Full HD 1080p
https://amzn.to/2nlc9FE
Recommended Advanced Formulas Book:
Ctrl+Shift+Enter: Mastering Excel Array Formulas (by Mike Girvin of ExcelIsFun fame)
======================================================================================
https://amzn.to/2ofPytU
Get more FREE Training on Up4Excel here: https://cutt.ly/ewsz9Sn
FREE Shortcuts Cheat Sheet »» http://www.up4excel.co.uk/shortcuts
======================================================================================
▶️ DTube
▶️ YouTube
Congratulations @up4excel! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :
You can view your badges on your Steem Board and compare to others on the Steem Ranking
If you no longer want to receive notifications, reply to this comment with the word
STOPVote for @Steemitboard as a witness to get one more award and increased upvotes!