New answers tagged google-sheets-cell-format
0
For me the easiest way is:
Copy the whole range you are planning to drag onto including the draggable item (select+ Ctrl+C)
Drag the item and break the formatting
Select the range and paste format only (Paste Special - Paste format only Or Ctrl+Alt+V)
1
Custom number formatting supports conditionals, but only two of them plus a default format. So, to display millions and billions of dollars, you can use Format > Number > More Formats > Custom number format with something like this:
[>999999999.999]$#.00,,, "B";[>999999.999]$#.00,, "M";$#,##0_M
Unfortunately, this will ...
Top 50 recent answers are included
Related Tags
google-sheets-cell-format × 58google-sheets × 57
formulas × 16
formatting × 5
google-apps-script × 4
conditional-formatting × 4
google-sheets-dates × 4
google-sheets-query × 2
google-sheets-arrayformula × 2
links × 2
if-this-then-that × 2
text-formatting × 2
google × 1
concatenate × 1
importhtml × 1
microsoft-excel × 1
google-finance × 1
copy-paste × 1
unicode × 1
google-sheets-import-csv × 1
google-sheets-protection × 1