How to Create a Number Column in SharePoint
Numbers are for counting, calculating, and aggregating. Use Number columns for anything you might want to sum, average, or do maths on.
What it is
A Number column stores numeric values — integers, decimals, percentages — and prevents users from accidentally entering letters or symbols that would break calculations. The big advantage over text is mathematics: you can sum, average, calculate min/max, and aggregate cleanly across views.
Common uses include quantities (how many?), scores (out of 10), priority levels (1-5), percentages (completion %, satisfaction score), and ratings. Where Currency is more appropriate (financial values with a symbol), use that instead — but for everything else numeric, Number is the clean choice.
The ‘Show as percentage’ option is a quiet timesaver. Enter 0.75 and SharePoint shows 75%. Enter 1.0 and it shows 100%. Saves users from typing the % symbol every time and keeps the underlying data clean as a decimal — perfect for calculations and reports.
When to use this
- For quantities, counts, scores, ratings, percentages.
- For priority levels, severity scores, complexity ratings.
- Whenever you might want to sum or average across a view.
- Not for currency — use Currency column for financial values.
How to do it
- Click + Add column → Number.
- Set decimal places (0 for counts, 2 for percentages).
- Optionally set min/max values to prevent invalid entries.
- Choose ‘Show as percentage’ if appropriate.
- Save and enable Totals in your view (sum, average, max, min).
- Use in calculated columns for derived values.
Best practices
- Use Number for anything mathematical. Even a count column should be Number, not text.
- Set min/max constraints. Prevents typos like ‘12345’ instead of ‘5’.
- Use percentage display where it fits. Cleaner than asking users to type %.
- Enable Totals in views. Free reporting at the bottom of every column.
Common mistakes
- Storing numbers as text. Breaks sorting (10 sorts before 2), breaks calculations, breaks averages.
- Too many decimal places. ‘Project complete: 73.4521%’ is false precision. Round to 1 or 2 decimals.
- No min/max validation. Users will type 100 instead of 1 and break your reports.
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 Number column in SharePoint?
A Number column stores numeric values — counts, scores, percentages, quantities, durations. SharePoint can aggregate them (sums, averages at the bottom of views), sort them numerically (so 10 comes after 9, not before), and filter by ranges. Use it for any value where the maths matters.
Should I use a Number column for phone numbers and postcodes?
No. Phone numbers, postcodes, employee IDs, and version codes look numeric but they’re identifiers, not quantities. Number columns strip leading zeroes (00123 becomes 123), break the formatting, and produce nonsense if anyone tries to sum them. Use Single Line of Text instead.
How do I show a SharePoint Number column as a percentage?
In the column settings, tick Show as percentage. The underlying value is still a decimal (0.25), but it displays as 25%. Set decimal places to 0 or 1 depending on precision needed. Use min/max validation (0 to 100, or 0 to 1 depending on input convention) to catch errors like a value of 200 being typed.
Can I show a total at the bottom of a Number column view?
Yes. Edit the view, go to the Totals section, and choose what to display for each column — Sum, Average, Min, Max, Count. The total appears at the bottom of the column. Powerful for summary views (‘total invoice value this quarter’, ‘average completion score’).