Function 04)


Add Function CONVERTCENTSTOENGLISH to active workbook

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