We have recently released a series of useful custom formulas that help you convert an integer to a word representation of it. The new custom formulas are:
| Formula Name | Sample Usage |
|---|---|
| NUMBERSTOWORDS({Number}) | NUMBERSTOWORDS(11) => eleven |
| NUMBERSTOORDINALS({Number}) | NUMBERSTOORDINALS(11) => 11th |
| NUMBERSTOWORDORDINALS({Number}) | NUMBERSTOWORDORDINALS(11) => eleventh |
NUMBERSTOWORDS({Number}): Converts an integer to a word representation of that integer. If the number contains a decimal, the decimal will be ignored. The function parameter can be a reference to a Woodpecker field or a raw string.
NUMBERSTOORDINALS({Number}): Converts an integer to a string with the ordinal postfix of that number. If the number contains a decimal, the decimal will be ignored. The function parameter can be a reference to a Woodpecker field or a raw string.
NUMBERSTOWORDORDINALS({Number}): Converts an integer to the ordinal word representation of that integer. If the number contains a decimal, the decimal will be ignored. The function parameter can be a reference to a Woodpecker field or a raw string.
For additional information as well as our full selection of formula options, please check out our Formula Documentation.
