Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=19)
-   -   What is the formula for converting numbers in words? (https://www.askmehelpdesk.com/showthread.php?t=782371)

  • Jan 24, 2014, 08:02 AM
    rockfortvijay
    What is the formula for converting numbers in words?
    In MS Excel, we are preparing our invoices. Finally the total amount should be in words also. For that purpose every time we have to type the words. It is a boring and leborious work to me. Kindly help me with any shortcut formulae for the above purpose please.
  • Jan 24, 2014, 09:03 AM
    ebaines
    Check out this article - it gives you code for a VBA module that seems to work pretty well:

    How to convert a numeric value into English words in Excel

  • All times are GMT -7. The time now is 12:49 PM.