Home

Excel NumToWords Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-727433%22%20slang%3D%22en-US%22%3EExcel%20NumToWords%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-727433%22%20slang%3D%22en-US%22%3E%3CP%3ETo%20revel%20my%2020th%20week%20as%20a%20member%20of%20this%20EXCELlent%20Community%2C%20I%20hereby%20share%20my%20NumToWords%20formula.%20Delve%20into%20it%20in%20the%20attached%20file%20and%20please%20apprise%20me%20of%20your%20thoughts%20thereon.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-727433%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-749284%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20NumToWords%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749284%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOutstanding%20work%2C%20really%20amazing%20and%20very%20much%20useful%20specially%20for%20finance%20people.%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-749314%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20NumToWords%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749314%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20compliment.%20Incidentally%2C%20you%20need%20not%20copy%20the%20workbook.%20You%20only%20have%20to%20copy%20the%20formula%20to%20any%20cell%20other%20than%20those%20in%20Column%20A%20and%20it%20will%20convert%20the%20number%20to%20its%20left%20to%20words.%26nbsp%3B%3C%2FP%3E%3CP%3EThereafter%2C%20you%20can%20convert%20any%20number%20in%20the%20same%20workbook%20by%20entering%20this%20formula%20in%20the%20cell%20to%20its%20right%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DNumToWords%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Twifoo
Trusted Contributor

To revel my 20th week as a member of this EXCELlent Community, I hereby share my NumToWords formula. Delve into it in the attached file and please apprise me of your thoughts thereon.

2 Replies
Highlighted

@Twifoo 

Outstanding work, really amazing and very much useful specially for finance people.

Tauqeer

@tauqeeracma 

Thanks for your compliment. Incidentally, you need not copy the workbook. You only have to copy the formula to any cell other than those in Column A and it will convert the number to its left to words. 

Thereafter, you can convert any number in the same workbook by entering this formula in the cell to its right: 

=NumToWords

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies