Skip to main content

Posts

Showing posts with the label Microsoft Excel

Converting Numbers into Words in Excel

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", ...