SPELLNUMBER
SPELLNUMBER(number [,unit_plural] [,unit_single] [,decimal_plural] [,decimal_single] [,display_fraction] [,include_and] [,include_only] [,include_commas])
Returns the text after converting a number into words.
| number | The number you want to spell out. |
| unit_plural | (Optional) The unit to use for whole numbers. |
| unit_single | (Optional) The unit to use for 'single' whole numbers. |
| decimal_plural | (Optional) The unit to use for decimal numbers. |
| decimal_single | (Optional) The unit to use for 'single' decimal numbers. |
| display_fraction | (Optional) A logical value indicating if the decimal is displayed as a fraction: False = 0.5 is displayed as 50 (default) True = 0.5 is displayed as 50/100 |
| include_and | (Optional) A logical value indicating if the text contains the 'and' word: False = and is not included (default) True = and is included |
| include_only | (Optional) A logical value indicating if the text is appended with the word 'only': False = only is not included (default) True = only is included |
| include_commas | (Optional) A logical value indicating if the text contains commas: False = commas are not included True = commas are included (default) |
REMARKS
* At the moment this function only supports the English language.
* If a number contains more than two decimal places this function will spell out the number as if it was rounded to two decimal places.
You can use the add-in SPELLNUMBERREVERSE function to go in the opposite direction.
This function returns the same value for positive and negative numbers.
All numbers will be rounded to the nearest 2 decimal places.
This function will only return the correct text for numbers less than 999,999,999,999,999 (nine hundred trillion).
link - http://cpap.com.br/orlando/excelspellnumbermore.asp
link - support.microsoft.com/en-gb/office/convert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98
link - www.allmath.com/TexttoNumberConverter.php
 |
|
MORE FUNCTIONS
??
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext