Select the amount cells and press Ctrl + Shift + 4 to apply currency formatting in Google Sheets. Google lists the same Control-based shortcut for Mac.
Apply the currency shortcut
The example contains 1299.5, 48 and 215.75 in B2:B4. In the tested US-locale sheet, they display as $1,299.50, $48.00 and $215.75.
- Select B2:B4, or your own amount range.
- Press Ctrl + Shift + 4. On a Mac, use Control, not Command.
- Check the currency symbol and decimal places.
Choose a different currency
Use Format > Number > Custom currency when you need a particular symbol. Choose the currency and desired decimal display, then apply it to the selected amounts.
Keep the underlying amount numeric
Formatting changes the display, not the stored amount. A formatted 1299.5 still works in SUM and other calculations. It does not convert dollars into another currency.
Fix text that will not format
A number stored as text may retain its old appearance. Remove inappropriate text or use VALUE with a supported numeric string before formatting. Preserve identifiers whose leading zeros matter.
Change or remove the display
Use the toolbar decimal buttons to adjust visible precision. Format > Number > Number returns to a plain numeric display. Formatting does not restore precision already lost from the original data.
Other Google Sheets articles you may also like