How to Format Currency in Google Sheets

There are many different currencies in the world, and you can format each of them in different ways. For example, for US dollars, you can format them to have the dollar sign or the letters "US" in front of the dollars. Please check here if you work with Microsoft Excel.

Step 1: Select the numbers you want to format as currency;

Step 2: Click the "Format" tab from the ribbon, and click the "Number" command from the drop-down list;

Step 3: In the extended list, click "More formats" at the bottom and then "More currencies";

Step 4: In the "Custom currencies" window, select the currency type, e.g., US dollar;

Step 5: Click the arrows after the currency and choose one currency type from the list, e.g., "USD $1,000.00";

Step 6: You will see the numbers are now in the currency format with "USD $" in front of the numbers.

Step 7: If you want to format the dollars into the accounting format, please click the "Format" tab from the ribbon and then select "Number" from the list, the same as in step 2; then in the extended list, select "Accounting" from the drop-down list;

Step 8: The currencies are now in the accounting format with the dollar sign align on the left and numbers align on the right.

Leave a Reply