Amount in words

Google Sheets guide · 21 October 2026

Pounds and pence in Google Sheets without Apps Script

Turn 1250.05 into “One thousand two hundred and fifty pounds and five pence” in a spreadsheet. Import our free worksheet into Google Sheets: its ordinary formulas calculate the wording without a script, add-on or custom-function installation.

Using Microsoft Excel instead? Follow the Excel worksheet guide. For a single amount without a spreadsheet, use the online pounds converter.

Get the worksheet to import

Download the GBP worksheet (.xlsx)

This is the same original file used by our Excel guide, not a shared public Google Sheet. We require no sign-up; you need your own Google account to use Google Sheets. It handles 20 rows at a time, from 0 to 999,999,999.99, with at most two decimal places.

Privacy: when you import the file into Google Sheets, Google stores and processes the file and figures you enter under your account settings. If you need browser-local conversion without uploading figures, use our pounds converter instead.

Import it as a new Google spreadsheet

These steps assume the desktop Google Sheets website and English menus. Menu names can differ on a phone or in another language.

  1. Save the download above. Leave it as an .xlsx file. There is no Apps Script code to paste or extension to install.
  2. Open Google Sheets and choose Blank. Sign into your own Google account if needed. This creates a separate starting file, away from any existing accounts or invoices.
  3. Click File → Import → Upload. Choose the downloaded pounds-and-pence-in-excel.xlsx file from your computer.
  4. Choose Create new spreadsheet, then Import data. Do not choose Replace spreadsheet on a file containing your work. Open the new spreadsheet when prompted.
  5. Check the three tabs at the bottom: Amounts, Calculation and Words. Keep all three; the wording formulas depend on the other two tabs.

This uses Google's documented Excel-to-Sheets import workflow. Opening an Excel file for Office-format editing is a different workflow; the checks below were performed after conversion to a native Google spreadsheet.

Enter pounds, then copy the words

  1. Click the Amounts tab. Replace the yellow example inputs in A9:A28. Enter a numeric value such as 1250.05, not text such as £1,250.05.
  2. Look at column C. “Ready” means the entry passes the input checks. If it asks for a number, check that your input is a numeric cell rather than text. Clear unused cells instead of filling them with zero.
  3. Copy the words from column B. To put them in another spreadsheet without copying the dependent formula, use Edit → Paste special → Values only in the destination. Do not copy the output formula on its own to an unrelated file.

If your spreadsheet uses a decimal comma, follow its locale's numeric-entry conventions and confirm the displayed amount before using the result. Pasting a column works in groups of 20; paste values only into the input cells to retain the formatting.

£0.01
Zero pounds and one penny
£1.01
One pound and one penny
£1,250.05
One thousand two hundred and fifty pounds and five pence
£1,000,001.01
One million and one pounds and one penny

Why not BAHTTEXT or SpellNumber?

BAHTTEXT is not an English pounds-and-pence function. Google's BAHTTEXT documentation specifies Thai wording with baht and satang. A number format such as £0.00 displays digits; it does not spell them out.

Typing =SpellNumber(A2) into an empty sheet does not add a custom function. This worksheet instead keeps a visible Words lookup and a Calculation tab. Use the provided Amounts cells; there is no script authorisation or macro-security setting to change.

What was checked, and what it does not do

  • Native Google Sheets checks, 21 October 2026: 100 numeric cases matched our British-English GBP converter, including penny, thousand, million and maximum-amount boundaries. Eight blank or invalid-input cases were also checked. Inputs were changed and the recalculated outputs read back; this was not just an Excel preview.
  • GBP only: this is wording, not currency conversion, tax calculation or a judgement about what your bank or organisation accepts. Check the amount and final text before using it.
  • No silent extra-decimal rounding: an input such as 1.005 is rejected. Decide any required rounding in your source calculation first, then verify the amount.
  • Cloud spreadsheet, not browser-local storage: the file contains no macros, tracking or external data connections, but Google handles your imported copy. Follow your organisation's file and data policies.

The tests cover this worksheet after native import, not every Google Sheets locale, mobile app or Excel version. They are not bank certification. For a quick one-off result, return to the pounds and pence converter.