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