How to Create a Currency Column in SharePoint
When the data is money, use a Currency column. It handles symbols, decimals, and totals correctly — and prevents the embarrassing ‘is that dollars or pounds?’ moment.
What it is
A Currency column is a specialised Number column for financial data. It enforces a fixed number of decimal places (usually 2), shows a currency symbol (configurable per column or per organisation), and behaves correctly for sums, averages, and reporting. Where a Number column would store 1500, a Currency column shows $1,500.00 — making the value instantly readable.
Currency columns are essential for invoice trackers, project budget logs, expense registers, contract value libraries, and any list where money matters. The format is consistent across all entries (no users typing ‘$’ before some values and not others), the decimal handling is correct (no rounding errors), and the totals at the bottom of views are immediately useful.
For multi-currency organisations, the picture gets more complex — SharePoint Currency columns are single-currency by default. If your organisation deals in multiple currencies, you’ll typically have a separate column for the currency code (USD, GBP, EUR) and use the Currency column purely for the numeric value, formatted as your default currency. For more sophisticated multi-currency handling, Lists or a dedicated finance system is usually a better fit.
When to use this
- For invoices, budgets, expenses, contract values, fees, costs.
- Anywhere you need money values displayed cleanly.
- When totals or averages of money matter (budget tracking, expense reporting).
- Not for percentages or non-financial numbers.
How to do it
- Click + Add column → Currency.
- Choose the currency format (e.g. $ for USD, £ for GBP).
- Set decimal places (almost always 2).
- Decide if it’s required.
- Save and enable Totals in views to see sums.
- For multi-currency orgs, add a separate Choice column for currency code.
Best practices
- Match the format to your local currency. Don’t display USD if everything is in AUD.
- Enable Totals at view level. Sum at the bottom of the column for instant budget visibility.
- Pair with a Date column for time-bound reports. ‘Total spend this quarter’ is a one-click view.
- For multi-currency, add a separate currency code column. Don’t try to mix currencies in one Currency field.
Common mistakes
- Storing money in a Text or Number column. Loses formatting, complicates reporting.
- Mixed-currency in one column. $1000 and £1000 are not the same. Separate the value from the currency code.
- Wrong decimal places. Three decimals on currency is unusual. Stick with 2 unless you have a real reason.
The File Sanity Kit gives you the Container Method™ — audit, restructure, and future-proof SharePoint without IT admin. The complete methodology, full workbook, and 8-tab Excel planner.
Get the File Sanity Kit — $27 →FAQ
What is a Currency column in SharePoint?
A Currency column is a specialised Number column for financial values. It stores numbers but displays them with the currency symbol, thousand separators, and decimal places for your chosen region (£1,234.56 in the UK; $1,234.56 in the US; €1.234,56 in much of Europe). The underlying data is the same — the formatting makes it readable.
Can I have multiple currencies in one SharePoint column?
Not natively. A Currency column displays one currency format only. If you need multi-currency, you have two options: either create separate columns for each currency, or use a Number column plus a Choice column for the currency code (e.g. Amount = 1234.56, Currency = GBP). The latter is more flexible but requires more work in reports.
How many decimal places should a Currency column have?
Two — the standard for currency in most regions. Set it explicitly in the column settings rather than relying on defaults. For organisations dealing in fractional cents or precision financial calculations, you might need more, but for invoices, budgets, and most project costs, two decimals is right.
Can I show a total of a Currency column?
Yes. Edit the view, set Totals to Sum on the Currency column, and the total appears at the bottom — formatted in the right currency. Powerful for budget summaries, invoice totals, expense reports. Combine with grouping (group by Department, total by Department) for slice-and-dice views.