File Portable Download: Convert Number To Words In Excel

Close the VBA window. Go to and ensure you select Excel Macro-Enabled Workbook (.xlsm) . If you save it as a standard .xlsx file, the conversion code will be deleted. 💡 How to Use the Function

Yes. Inside the VBA code, search for the words "Dollars" and "Cents." You can manually replace them with "Pounds," "Euros," "Rupees," or any other currency of your choice. Does this work in Excel Online or Google Sheets? convert number to words in excel file download

Managing financial reports or invoices in Excel often requires displaying currency amounts in words. Whether you need to write "One Hundred Dollars" or "Fifty Euros," doing this manually is slow and prone to errors. Since Excel does not have a built-in "SpellNumber" function, you typically need to use a VBA macro. Close the VBA window

If cell A1 contains 125.50 , the formula will return "One Hundred Twenty Five Dollars and Fifty Cents." ❓ Frequently Asked Questions Can I change "Dollars" to another currency? 💡 How to Use the Function Yes

[]

Should the decimals be written as or as a fraction (e.g., 50/100)?

How to Convert Numbers to Words in Excel (Free File Download)