Step-by-Step: Gword Excel Add-in to Convert Numbers to Words

How to Use Gword to Convert Numbers to Words in Excel

Converting numbers to words in Excel is useful for invoices, checks, legal documents, and reports. Gword is a simple add-in (or macro-based tool) that converts numeric values into fully written words (e.g., 1,234 → one thousand two hundred thirty-four). This guide shows a clear, step-by-step process to install Gword (if needed), use it in common scenarios, and handle formatting and common issues.

1. Install or enable Gword

1. Download the Gword add-in file (usually a .xlam or .xla) from the provider or your organization.
2. In Excel: File → Options → Add-ins. At the bottom select Excel Add-ins and click Go…
3. Click Browse…, locate the Gword .xlam/.xla file, select it, and click OK. Ensure the Gword add-in is checked in the Add-ins list.
4. If Gword is a macro workbook, open it and enable macros when prompted. Save the add-in in a trusted location if Excel blocks it.

2. Basic usage (single cell)

1. Place a numeric value in a cell, e.g., A2 = 1234.56.
2. In the target cell, enter the Gword function. Common Gword function forms:
   • =GWORD(A2) — converts the number in A2 to words (default style).
   • =GWORD(A2, “USD”) — converts with currency name/symbol.
   • =GWORD(A2, 2) — converts with specified decimal precision or style (implementation depends on the add-in).
3. Press Enter. The cell displays the number in words, e.g., “one thousand two hundred thirty-four and ⁄₁₀₀” or “one thousand two hundred thirty-four dollars and fifty-six cents” depending on settings.

3. Converting ranges and filling down

1. If you have multiple numbers (A2:A10), enter the formula in B2: =GWORD(A2)
2. Drag the fill handle down from B2 to B10, or double-click the handle to auto-fill. Each row will convert its corresponding number.

4. Currency and formatting options

• Currency: Use the add-in’s optional parameter to show currency words (e.g., USD, GBP). Example: =GWORD(A2, “USD”) → “one hundred twenty-three dollars and 45 cents.”
• Capitalization: Some Gword versions offer options like “Title Case” or “All Caps”: =GWORD(A2, , “Title”) or =GWORD(A2, , “UPPER”). Check the add-in help for exact parameter order.
• Decimal handling: Specify whether decimals become fractional words (⁄₁₀₀) or full words (fifty-six hundredths).

5. Using Gword in templates (checks, invoices)

• Insert the formula where you want the written amount to appear. Use cell-formatting to lock the numeric amount (protect the cell) so users can only change the numeric input.
• Combine with CONCAT or & to add text: =“Amount in words: “&GWORD(A2,“USD”,“Title”).

6. Common issues and fixes

• #NAME? error — Excel doesn’t recognize GWORD: ensure the add-in is installed/enabled and macros are allowed. Check spelling and function name case.
• Wrong language or currency — Verify add-in settings or use the correct currency code parameter.
• Large numbers truncated — Some versions limit maximum value. If needed, split into parts (millions and remainder) and combine with formulas.
• Localization (comma vs dot) — Ensure Excel regional settings match number formats used by Gword.

7. Security and trust

• Only install Gword from trusted sources (company IT or the official provider). If the add-in requires macros, store it in a Trusted Location and enable macros only if you trust the file.

8. Example formulas

• Basic: =GWORD(A2)
• With currency: =GWORD(A2,“USD”)
• With capitalization (example syntax): =GWORD(A2,“USD”,“Title”)

9. Troubleshooting steps checklist

1. Confirm Gword add-in file is present.
2. Ensure add-in is checked in Excel Add-ins.
3. Enable macros and add-in trust if needed.
4. Verify correct function name/parameters.
5. Test with a simple number (e.g., 123) to validate behavior.

This workflow should let you convert numbers to words in Excel using Gword quickly and reliably. If you tell me your Excel version and the exact Gword function signature (or paste the add-in’s help text), I can provide the precise formula syntax for your setup.