Function 05)

05) Add Function ConvertCurrencytoEnglish

Using the function

=ConvertCurrencytoEnglish(YourValue)

You can obtain the value displayed as words like you would see on a check.

This formula:       =ConvertCurrencytoEnglish(10123.72)
Would return:         Ten Thousand One Hundred Twenty Three Dollars And Seventy Two Cents

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc