Custome decimal format: always show decimal place

Questions & Answers
1

Hi,

I frequently use a custom decimal format (#,###.#) to reduce clutter on the report. This results sometimes in figures like “4.” because the actual value “4.04” has been rounded. Is there a way to actually force the figure to be shown as “4.0” as it gives a “broken look” in my opinion.

2

Hi Maiko,
To always show one decimal place (even for whole numbers), use the format pattern #,##0.0 instead of #,###.#.
This will ensure numbers are displayed as “4.0” rather than “4.”.

I hope this helps.

Best,
Ilze

1 Like