formattinggoogle sheetsgoogle-sheets-cell-format
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.
For example:
1,234.56789 => 1,234.5681,234.5 => 1,234.51,234 => 1,2341,234.00 => 1,234I tried #,#.#, but then the period shows up always. #,#.0 doesn't omit the decimal point when its value is zero.
Maybe this has been fixed in New Google Sheets because it works for me (indeed, it is VERY simple):
Select A1:B3, Insert, Chart..., click Line chart, Insert.
Seems happy to work with DMY format and, as it happens, text for dates (since happening to be 4 months apart the x-axis spacing to be equal is about correct anyway).
What you're looking for is conditional number formatting. You can do this in the Google doc by highlighting the column you wish to format and clicking:
Format → Number → More Formats → Custom number format...
Thereafter, specify this as your formula:
[<10]_(###0.00_);_(#0_)
What it means is, if the cell value is less than 10 then format the cell in #,##0.00 format otherwise format as #0.
You can read more info over here:
Display decimals only when the number is less than 1 [Excel number formatting tip]
As well as here:
Best Answer
closest you can get is to use 1+ column
=IF(RIGHT(A2;1)=".";SUBSTITUTE(A2;".";"");A2)https://docs.google.com/spreadsheets/d/