Does anyone know how to get rid of the annoying decimal point for whole numbers?
For example, 10 formatted as "0.##" produces "10.".
Excel number formats
-
ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
so you'd want ...
10.1
10
25.232
I think you can do it with conditional formatting and 'use a formula to determine which cells to format' eg a1 = int(a1)
Where that's the case format it as zero DPs or a custom ###,### format.
I'm not 100% about that but it might work, because I don't think you can do it with normal cell formatting.
10.1
10
25.232
I think you can do it with conditional formatting and 'use a formula to determine which cells to format' eg a1 = int(a1)
Where that's the case format it as zero DPs or a custom ###,### format.
I'm not 100% about that but it might work, because I don't think you can do it with normal cell formatting.