I'd like to have a custom format in which the decimal point is handled the way "General" handles it, i.e. the point is there if and only if there is one or more digit to come after.
In particular, I want to add thousands separators (commas) without changing the decimals behavior. I've made a few attempts. Of course I can get the number of decimal places to grow as needed (#,###.####) but the dot still appears even for an integer.
Before anyone says it, yes, I can do this with conditional formatting. One should not have to do that, since this is really only a number formatting matter, and conditional formatting would be a workaround.
Bookmarks