Function 04)
04) Add Function ConvertCentstoEnglish
Using the function
=CovertCentstoEnglish(YourValue)
You can obtain the cents displayed as words like you would see on a check.
This formula: =ConvertCentstoEnglish(123.564)
Would return: Fifty Six and Four Tenths Cents
Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc