Formulas to Convert Numbers to Words

“Formula” fields bring the power of Excel formulas directly into Woodpecker. By utilizing “Formula” fields, you can perform mathematical operations on other Woodpecker fields and automatically calculate the dynamic data that your document needs.

When creating a formula field, the formula may contain static values, references to other fields, or both. Almost anything you can do in Excel, you can do with a Woodpecker field.

Woodpecker+formulas

One of the most commonly used Formulas is the ability to convert numbers to words.

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.

You can read more about using Formulas in our Help Center.