 # Convert Numbers To Words

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.

2 Likes

I can’t get this to work. I’m trying to refer to another field as part of a conditional.
NUMBERSTOWORDS({2}) produces

NUMBERSTOWORDS(2)

What sounds like may be happening is in the conditional field, you are referencing the formula text in a Single line text field. In conditionals, formula fields are not supported directly. Therefore, you have to create a formula “helper” field and reference this field in the conditional using Macros.

I have an example of this below.

All fields: Formula Field: Conditional Field: