Google Sheets 並未內建將數字拼成英文單字的功能，因此要把 1234 轉換成 "one thousand two hundred thirty-four" 必須仰賴自訂的 Apps Script、市集外掛，或是將外部拼字工具的輸出貼到儲存格中。Number to Words Converter 屬於第三種方式：一個瀏覽器頁面，可一鍵將介於 minus 999,999,999,999 與 999,999,999,999 之間的任意完整整數轉為小寫的美式英文基數拼法，整個過程無需 Google 帳號、外掛權限或指令碼編輯器。由於解析與分組都在當前分頁中完成，您輸入的數值絕不會被傳送到伺服器或儲存到工作表，這在數字屬於隱私資料時格外重要。您只要輸入數字、點選轉換按鈕、複製產生的單字，再直接貼到儲存格即可——當發票標籤、工作表提示、閱讀測驗段落，或任何用單字閱讀比用數字更自然的文件需要固定拼法時，這個方法就能派上用場。
Why Google Sheets Has No Built-In Number-to-Words Function
Spreadsheets are built for arithmetic, and Sheets inherits a small library of TEXT, DOLLAR, and FIXED helpers that format numbers as digits, currency strings, or fixed-precision decimals. None of them rewrites an integer as its English name. The Google Sheets function reference has documented this gap for years, and community guides typically reach for one of three workarounds: paste a custom function written in Google Apps Script, install an add-on such as NUMBERTEXT from the Marketplace, or copy a spelling from a separate tool. Each path has trade-offs that matter when you just want a clean word version of a single cell.
Apps Script gives full control but requires the script editor, a trigger or custom function declaration, and the right OAuth scopes for the sheet that holds the values. Marketplace add-ons handle the spelling for you but require granting access to the spreadsheet, depend on the publisher staying online, and may localize the output in ways that are hard to predict. A standalone browser tool sidesteps both concerns: the spreadsheet stays untouched, no third party ever sees the digits, and the output rule is fully documented in one place. That is the role the Number to Words Converter is designed to fill.
Convert a Number to Words for Google Sheets in Three Steps
- Open the Number to Words Converter in a browser tab next to your sheet.
- Type the integer you want spelled into the input field, optionally with a leading plus or minus sign and standard three-digit comma groups such as 12,345,678 or -999,999,999,999.
- Select Convert to words, glance at the normalized numeric value the tool displays underneath the result to confirm the parser read your input correctly, then copy the lowercase spelling and paste it into the destination Sheets cell.
Because the converter never touches the sheet itself, you can repeat the workflow for as many cells as you need. The input field stays editable, so changing the value clears the previous result automatically and prevents an older spelling from being mistaken for the current number.
Input Formats the Converter Accepts and Rejects
The parser follows a strict input grammar so the output stays deterministic. The accepted forms are easy to remember; the rejected forms are easy to spot because the converter raises an explicit error rather than silently repairing the digits.
| Format | Example | Result |
|---|---|---|
| Plain digits with optional sign | 1234567, +42, -500 | Accepted; leading plus signs do not affect the normalized value, while a leading minus is preserved on negative values |
| Three-digit comma groups | 1,000, 12,345,678 | Accepted when every group after the first contains exactly three digits |
| Leading zeros | 00123 | Accepted; normalized value is 123, no effect on the spelling |
| Irregular comma groups | 12,34, 1,0000 | Rejected; the parser refuses to guess the intended grouping |
| Negative zero | -0 | Normalized to 0, no minus sign returned |
The grammar is intentionally narrow so you can paste digits straight from a sheet without first scrubbing dollar signs, parentheses, or trailing decimals. If the cell holds a currency-formatted value, strip the currency symbol and decimal portion in Sheets first, then run the cleaned integer through the converter.
How the Spelling Rules Work — Hyphens, Hundreds, and Empty Groups
The converter follows a documented US-English profile that uses the short scale familiar from everyday American writing: one thousand for 1,000, one million for 1,000,000, and one billion for 1,000,000,000. It splits the absolute value into three-digit groups, spells each occupied group, attaches the scale name, and reinserts the sign. A few small rules control the join.
Values from zero through nineteen use their established individual words. Exact multiples of ten from twenty through ninety use twenty, thirty, forty, fifty, sixty, seventy, eighty, and ninety. When a nonzero ones digit follows one of those tens, the words are joined with a hyphen, so 25 becomes twenty-five and 99 becomes ninety-nine. Hundreds take the digit word followed by hundred, and the profile deliberately drops the optional conjunction and so 105 is rendered one hundred five. Empty groups between occupied groups are skipped, so 1,000,001 reads as one million one rather than inserting a zero group.
To see those rules in one place, walk 1,234,567 through the converter:
- Absolute value: 1234567, no sign.
- Three-digit groups from left to right: 1 | 234 | 567.
- Group 1 with the millions scale: one million.
- Group 234 with the thousands scale: two hundred thirty-four thousand.
- Group 567 with no scale: five hundred sixty-seven.
- Combined spelling: one million two hundred thirty-four thousand five hundred sixty-seven.
Each step comes from the tables the converter checks against the Unicode LDML rule-based number formatting reference and a published English number guide, so the same input always produces the same output.
Limits, Negative Values, and Inputs That Stay Out of Scope
The converter accepts integers only, bounded between minus 999,999,999,999 and 999,999,999,999. That ceiling keeps the vocabulary limited to billion while still covering twelve-digit whole numbers and avoiding the floating-point rounding that would creep in if the parser used JavaScript Number for the full value; the underlying implementation uses BigInt for the complete integer and only converts each three-digit group to a small Number for table lookup. Negative values keep their minus sign, and negative zero collapses to plain zero because the cardinal spelling has no distinct form for it.
Several common inputs are explicitly out of scope:
- Decimals and fractions such as 3.14 or 1/2.
- Scientific notation, including 1.5e6.
- Currency symbols, accounting parentheses, and embedded spaces inside digits.
- Hexadecimal prefixes and written-out number phrases like "twelve thousand".
- Year readings, cheque phrases, telephone-number groupings, ordinals, and digit-by-digit pronunciation.
For legal, financial, or contractual wording — invoice totals, cheque amounts, rupee or dollar expansions — review the converted string on its own and append the currency name, fractional cents, or jurisdiction-specific wording separately. The output is a deterministic cardinal string, not financial or legal advice. If you need to go the other direction and turn a written phrase back into digits, the related Words to Numbers Converter handles the inverse in the same browser tab.
Other Ways to Get Spelled Numbers Into Sheets
The Number to Words Converter is one path, but Sheets users often weigh three. The table below summarizes how they differ along the dimensions that matter when you are working inside a spreadsheet.
| Approach | Setup needed | Comma-formatted input | Where the data goes | Spelling profile |
|---|---|---|---|---|
| Number to Words Converter | Open a browser tab | Accepted with strict three-digit groups | Stays in the local browser tab | Fixed lowercase US-English cardinal, no and |
| Apps Script custom function | Script editor, scopes, deploy | Depends on the code you write | Lives in your Apps Script project and the sheet | Whatever rules the script encodes |
| NUMBERTEXT Marketplace add-on | Install, grant access, formula | Varies by version and locale | Processed by the add-on publisher | Often localized; check before relying on a fixed string |
Reach for the converter when you have a handful of values, want one canonical spelling for documentation, or simply do not want to give a third party read access to the sheet. Reach for Apps Script when many cells must update live from changing formulas. Reach for the add-on when the rest of the workbook already depends on its ecosystem. If you only need a clean string for one cell, copying the converter's output is usually the fastest path. If you also need to rework the case of the surrounding text, a related guide on changing text case in Google Sheets without formulas follows the same browser-tab approach for a different formatting problem.
Related reading: Get a Random Word From a List: Python and Browser Options.