I'm trying to format a number in Google Spreadsheets. I want it to show the thousands comma, then a period
., followed by mostly 3 digits, only when necessary.
1,234.56789 => 1,234.568
1,234.5 => 1,234.5
1,234 => 1,234
1,234.00 => 1,234
#,#.#, but then the period shows up always.
#,#.0 doesn't omit the decimal point when its value is zero.