VnTools (Number to Words Converter Add-in for Excel & Word) v1.20

About VnTools - The Essential Vietnamese Office Automation Add-in

VnTools, created by software developer Nguyen Thanh Dieu, is a celebrated productivity add-in deeply integrated into the daily workflows of accountants, financial analysts, and administrative professionals throughout Vietnam. In accounting ledger processing, invoice generation, and payroll spreadsheets across Microsoft Excel and formal documentation in Microsoft Word, converting numeric currency sums into formal written Vietnamese text is a mandatory requirement.

Rather than manually typing lengthy written amounts—which is labor-intensive and prone to typographical errors—VnTools introduces robust custom functions (such as =VND() and =USD()) that dynamically transcribe numerical figures into correct, grammatically sound Vietnamese words in real time.

Key Features

• Automated Number to Words Transcriber (=VND and =USD): Converts complex currency amounts (thousands, millions, billions) into formal Vietnamese written words with full diacritical accuracy. Supports currency suffixes and sentence-case formatting.
• Inline Word Document Conversion: Highlight any raw number in Microsoft Word and trigger the VnTools conversion toolbar to replace figures with text without leaving Word.
• Vietnamese Code Page & Font Transcoder: Easily resolve font corruption in legacy files by converting between the three primary Vietnamese encoding systems: Unicode, TCVN3 (ABC), and VNI Windows.
• Smart Name Splitting (First & Last Name): Automatically divides full Vietnamese names into separate First Name, Middle Name, and Surname columns, facilitating streamlined alphabetical sorting (A-Z).
• Spreadsheet Formatting Utilities: Remove blank rows rapidly, toggle alternating row zebra striping, and enhance visual spreadsheet readability with minimal effort.
• Case Manipulation Engine: Effortlessly convert text selections between UPPERCASE, lowercase, and Title Case.
• Featherlight & Broad Office Compatibility: Compact footprint under 1 MB, supporting Microsoft Office 2003 through Microsoft 365 on 32-bit and 64-bit Windows environments.

How to Install and Activate VnTools in Microsoft Excel

1. Download the official vntools.exe setup package and install it with Administrator privileges.
2. Launch Microsoft Excel.
3. Click File → Options → select Add-ins from the sidebar.
4. Under the Manage drop-down at the bottom, select Excel Add-ins → click Go....
5. In the Add-ins dialog, click Browse..., navigate to the VnTools installation folder (typically C:\Program Files (x86)\vnTools\), and select the Ufunctions.xla file.
6. Check the box next to VnTools and click OK.
7. The VnTools ribbon/toolbar is now active and ready for calculations.

Excel Formula Usage Reference

• Syntax: =VND(cell_reference) → Example: If cell A1 contains 1,500,000, entering =VND(A1) outputs "Má»™t triệu năm trăm nghìn đồng".