Function 04)
Add Function CONVERTCENTSTOENGLISH to active workbook
=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