[SOLVED]Custom format for decimal numbers

lueu

Hi!
Anyone know if (and how) I can write a custom format for decimal numbers that removes zeroes if any?

I have set the number of digits after decimal point to 6 (maximum), but for numbers that have zeroes after decimal point I would like these to be cut out, ex. 248.150000 would show as 248.15, 543.000000 shows as 543, but 256.486259 would show all 6 decimals.

There is no "Automatic" choice for the numbers after decimal point, unless there is a way to set this in Custom format. "#.#" does not work, this only gives one digit after the decimal point.

ACDC

try a variation of this in the custom format: #,##0.0000 or #,##0.00

lueu

Thanks for the tip! It didn't work exactly as I needed, but helped me understand how I could play with the custom format. Ended up with #.########## since I have 10 decimals, and this format seems to cut the last zeroes in line. Thank you 🙂