How to Convert Numbers to Words in Excel: A Step-by-Step Guide

hiyamedia

Press ALT+F11 on Excel, then go to Modules below on the left and paste the notepad text attached here. Save, close, and come back to Excel. Then in the formula for the cell, type =ntow(cell reference) [e.g., =ntow(A2) or =ntow(4168)]. That's it.

1 Attachment(s) [Login To View]

jalasayanan

This is very good. I used to write code using HLOOKUP, but this is more convenient. Hats off.

mdm_580@yahoo.co.in

Sorry, when using this command, it only works with a specific Excel sheet. When I open new files, this command doesn't run. Please advise.

hiyamedia

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute