I need the report to display a numerical value with both thousand's separator (comma) and decimals and also drop unnecessary zeros at the end of the number.
Input = 1001.1
Format Standard = 1,001.10
Format General = 1001.1
I want it to read 1,001.1
(Comma and dropping the zero at the end)
Decimal is set to Auto. If I increase it the decimal place shows even if it's 0 which I don't want.
When I try to use the Format function to display both commas and decimals it displays like the Standard format.