How to Use Currency Formatting in Google Sheets

Proper formatting in a spreadsheet can make it much easier for your audience to interpret the data that they are looking at. When the data in a row or column is uniform, it’s easier to spot problems or errors. This is particularly useful when you have monetary values in cells, as some of the values may have different numbers of decimal places, making it difficult to properly evaluate the data.

Google Sheets has a number formatting option that lets you tell the spreadsheet that values in certain cells are currency. Those values will then be preceded by a dollar sign, and will all have a uniform number of decimal places, thereby making it much easier to read the data. Our guide below will show you how to select cells and apply currency formatting to those cells.

 

How to Format Values as Money in Google Sheets

The steps in this guide were performed in the Web browser version of Google Sheets, specifically Google Chrome. This article assumes that you currently have cells in a Google Sheets spreadsheet that are not formatted as monetary values, but that you would like to be.

Step 1: Go to Google Drive at https://drive.google.com/drive/my-drive and open the spreadsheet containing the cells that you would like to format.

 

Step 2: Select the cells. Note that you can select an entire column by clicking the column letter, or you can select an entire row by clicking the row number.

select cells to format

 

 

Step 3: Click the $ sign in the gray toolbar above the spreadsheet.

how to format currency in google sheets

 

 

Alternatively you can format cells as currency by clicking the Format tab at the top of the window, clicking Number, then selecting one of the currency formats there.

additional google sheets currency formatting options

 

 

Do you have a spreadsheet in Google Sheets that has unwanted or incorrect fill colors? Learn how to remove fill colors from a spreadsheet if they are causing problems, or if you would simply prefer not to have them.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.