Well, actually MS Excel doesn't include any direct function to convert your numeric values into words. But with the help of Microsoft Visual Basic, you can input a module in your worksheet and convert numbers into English words. Let's do this - Applies to Excel 2003 Excel 2007 Excel 2010 Excel 2013 Excel 2016 Prepare Workbook for Conversion Run MS Excel (I'm using Excel 2016). Open a new/ blank workbook. Press Alt+F11 to open Microsoft Visual Basic. Go to the Insert Menu > Module > Copy and paste the following code in the blank box. Press Alt+Q to close and return to Microsoft Excel. Go to the file menu and save this workbook as Excel Macro-Enabled Workbook (*.xlsm) . I.e. Word Converter.xlsm. That's it! Function words(fig, Optional point = "Point") As String Dim digit(14) As Integer alpha = Array("", "One", "Two", "Three", "Four", ...
Your ultimate choice for Computer, Internet, Blogging, & PC Troubleshooting Tips!