Liam has provided financial modelling services and training to clients for more than two decades. A senior accountant and professional mathematician, he has worked in numerous countries with many int...
Updated Apr 24, 2020
Version 2.0
Blog Post
Thank you, Liam.
I'd love to see similar formatting capabilities as in the Excel Chart Axis, where you can format in Hundreds, Thousands, 10,000 , …
Business Case: Often, I need to display percentages without the % 'symbol' and in hundredths (1/100s), eg: show 0.63 as 63 and not 63%. A workaround is to multiply a cell expression by 100 and display it as a regular number and not a percentage, however any computation using this cell would need to be adjusted.
Note that it is possible to display a number in thousands, millions or multiples of x1,000 by adding a comma to the custom format:
#,##0 can be changed to #,##0, for thousands and #,##0,, for millions
Yet, no option for Hundreds or 1/100s.
(By the way, same thing for PowerBI, a percent without the % symbol would be great)