POPUP SPELL NUMBER for Microsoft Excel
This utility is a COM add-in or add-in (.xla) programmed in Microsoft® Visual Basic® for Application (VBA) that makes it possible to capture a number in Microsoft Excel®, configure its respective SpellNumber (write-out number, as in check writing protection) through a popup user interface, and insert it back in Excel or send it to the Microsoft Windows® clipboard to be immediately pasted into any Excel component (cell, formula bar, text box, comments etc.) or into another Windows application. All this can be done with only two keystrokes. It also makes available the fSpellNumber() worksheet function that can be used in cell formulas of all workbooks opened in your Excel.
It consists of only one file, the ExcelSpellNumber.dll, which is about 160 kb in size and can be installed automatically. Except for the DLL, no another setting is saved in the Windows Register. Its setting is saved in ExcelSpellNumber.ini, ExcelSpellNumberHotKey.xla, and ExcelSpellNumber.xlam files that are created and maintained by the proper utility. You can uninstall it totally and automatically, leaving no mess on your Windows Register or disc.
It has multiple settings to fit several ways of spelling fractions. For example:
205.02 (two hundred five dollars and two cents)
- Spells number configuring through a popup user interface. See the pictures below
- Makes available the fSpellNumber() worksheet function to all workbooks opened in Excel. See detailed description of this function here
- Instead the SpellNumber, can send to clipboard the correspondent Excel cell formula with fSpellNumber() function to be pasted in a sheet cell
- Captures number in the cell right-clicked by the mouse, through the SpellNumber command in popup shortcut menu
- If more than one number exists between text in the captured cell, all numbers are duly filtered and listed in the ‘Number’ ComboBox on the interface
- The small interface pops up close to the mouse cursor
- Modal or modeless interface
- With modeless interface, numbers or unit names can be captured by clicking in the Excel cell and then on the number or singular unit ComboBox
- The SpellNumber can be sent to Windows clipboard closing the interface immediately or not
- Has a command rose for inserting the SpellNumber above, below, left, right or over the selection and close the interface with only one mouse click. Since, when exiting and inserting, it always copies the SpellNumber to the Windows Clipboard too, an insert can be undone and the SpellNumber immediately pasted in another position
- Moreover can be undone, an inclusion does not break the current undo thread
- A number in the Windows clipboard can be pasted and re-entered as a SpellNumber. If more than one number between exists text, all numbers are duly filtered and listed in the ‘Number’ ComboBox on the interface
- The most recent setting is used as default in the next execution, but the default setting can be restored
- Five options exist for Spellnumber output: without brackets, between brackets; between brackets preceded by the corresponding number formatted according with the unit or vice versa; and formula
- Accepts the following hotkeys that make it possible to capture a number and insert its SpellNumber with only two keystrokes:
- Hotkey to popup: Any defined by user
- Before inserting and/or sending to clipboard, the user can configure the desired SpellNumber inserting or selecting options listed in the below ComboBoxes of the popup interface.
- Number ComboBox: Cardinal number, with or without fraction, to spell out.
The largest valid number: 1 trillion minus 0.01 (999,999,999,999.99)
- Unit Singular ComboBox: Unit name entry in the singular.
- Fraction Description ComboBox: Entry of options from 1 to 8 for manners of spelling (writing out) the fraction (Optional - Default 3 or 1 if there is UnitNameSing):
Spells the fraction in cent/cents. Ideal for coins
- Letter Case ComboBox: Entry of options from 1 to 4 provides choices for formatting letters in upper/lower case:
1 - all lower case
- If you need more options to configure your numbers correctly, you can click the ‘More options’ button to make the ComboBoxes below available:
- ‘One thousand’ ComboBox: Entry of the options for spelling out 1000, either omitting 'one' or not:
True (Yes, 'one thousand') or False (Not, 'thousand').
- Thousand comma ComboBox: Entry of the options for comma intercalation between thousand or not:
True (Yes) or False (Not);
- Unit Plural ComboBox: Unit name in the plural (Optional - In the lack the pluralization will be done automatically from unit name in singular, thus this only is necessary when the desired plural diverges from the language default as defined in the code).
- Occupies less than 150 Kb when installed.
Tested in Excel for Windows, versions 2000, 2002(XP), 2003, 2007, 2010 (32-bit), and 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365™ cloud-based services.
Note: The above link downloads the installer and uninstaller package programmed in VBA in a XLS duly converted to EXE by the XLtoEXE to make the installation easier for macro and Windows laymen; however, if you're an expert and for some reason prefer an installer and uninstaller package in open ZIP format, click here. With this zip package you can install it in three ways: (1) Simply initiate the Install.exe that loads the same XLS in Excel without macro alert; (2) Extract the entire package to a folder and initiate the XLS, enabling the macros in Excel and using 123 as password, or (3) Install the DLL manually.
When installing this utility in Excel 2002 or later (as add-in, Excel 97 or later), the fSpellNumber() worksheet function with the arguments described below remains available to any workbook opened on your Excel.
Note: If you are a VBA developer and have interest in this function code, it is available and better documented on this site at VBA Spell Number Function.
1º) Num -
The cardinal number with or without fraction to spell out
2º) FracType - 1, 2, 3, 4, 5, 6 or 7 for the way to spell (written out) the fraction (Optional - Default 3 or 1 if there is UnitNameSing):
Spells the fraction in cent/cents. Ideal for coin
3º) UndNameSing - Unity name in the singular (Optional - The lack denote pure number)
4º) UndNamePlur - Unity name in the plural (Optional - The pluralization will be done automatically from UndNameSing. This only is necessary when the desired plural diverges from the language default as defined in the code)
5º) UndMasc - Denote unity gender: True (masculine) or False (feminine) (Optional - Default True (masculine)) (Obs.: Although this isn't need in English, it stays here. Maybe it was useful to translate this for another language. The same for the number noun flexibility.)
6º) OneThousand - Spelling out 1000, either omitting 'one' or not: True (Yes, 'one thousand') or False (No, 'thousand') (Optional - Default True)
7º) ComBetThous - Denote Comma intercalation Between Thousands: True (Yes) or False (No) (Optional - Default False (Don't intercalate))
8º) LetterCase - Format letters in upper/lower case (Optional - Default 1):
1 - all lower case
can use the fSpellNumber() function directly on your workbook
cells. For example, if you had a number in the A1 cell, you can
put this formula in B1:
The COM add-in version available above to download is technically the best option because it consumes little Excel memory and does not delay its load, but, if you’re a special Excel user and prefer the add-in version (ExcelSpellNumber.xla) for some technical reason, I can make it available also with the same features as well as access to the source code. For this, it is necessary to become a special registered user. Click here to ask information about this special register.