PocoDash

If you’re using one of my Google Sheets templates to manage your business finances, track expenses, or monitor sales performance, you’ll likely want your numbers to show up as currency — especially when dealing with money💰!

Here’s a simple step-by-step guide on how to format numbers as currency in Google Sheets.

Why Format Number as Currency?

When you format numbers as currency:

• Your numbers become easier to read and interpret.

• Your report contains multiple currencies, and you need to differentiate them.
• It gives clarity to readers about the number they are reading. i.e. 100 can refer to 100 orders, 100 sales revenue in dollar or 100 items sold.)

Example Use Case

Let’s say you downloaded a budget tracker or sales tracker template. You’ll probably have columns like:

• Total Sales

• Monthly Budget

• Expenses

These are all perfect candidates for currency formatting.

Tutorial: How to Format as Currency in Google Sheets

Follow these steps to apply currency formatting:

Step 1: Select the cells

Click and drag to select the cell, column, or row you want to format.

Step 2: Go to Format → Number → Currency

From the top menu, click:

This will apply the default currency of your Google Sheets settings (mine is UK pound).

Step 3: (Optional) Change to another currency

If you need another currency like EUR, MYR, SGD, etc., follow these steps:

1. Select your cells again.

2. Click Format → Number → Custom currency (see screenshot below).

3. In the Custom Currencies window, choose the currency you want from the list.

4. Click Apply.

🌍 Bonus Tip: Set Your Default Locale

If your currency isn’t showing up correctly (e.g., using $ when you need £), it might be due to your locale settings.

To fix that:

1. Go to File → Settings

2. Under the General tab, find “Locale”

3. Choose the country that matches your currency

4. Click Save and reload.
   

Once refreshed, you’ll notice the currency symbol in the toolbar has been switched based on the country selected.

Want a plug-and-play dashboard that automatically tracks key business metrics and revenues?
Try my Multipurpose KPI Tracker for Google Sheets — it includes pre-built formulas, trend analysis, and supports multiple currencies.