FAQ
FAQ
In formal documents or certain special circumstances, numbers are sometimes written out in words. For example, you might use "one hundred" to represent "100". You can use the SPELLNUMBER formula if you need to convert numbers into words.
Formula Format: SPELLNUMBER(number, [lang])
1. number: The number or field you want to convert.
2. [lang]: Optional. Specifies the language for conversion. Defaults to English if not provided. Supported languages are listed in the table below:
| Language | [lang] |
|---|---|
| Traditional Chinese | cht |
| Simplified Chinese | chs |
| English | en |
| French | fr |
For example, let's say G1 is a numeric field with the value 100,032.02. Below are the results when the SPELLNUMBER formula is applied in other fields that reference G1.
| Formula | Result |
|---|---|
| SPELLNUMBER(G1) | one hundred thousand and thirty-two point zero two |
| SPELLNUMBER(G1,'cht') | 壹拾萬零參拾貳點零貳 |
| SPELLNUMBER(G1,'fr') | un cents mille trente-deux point zéro deux |
