POPUP SPELL NUMBER for Microsoft PowerPoint
This utility is a COM add-in or add-in (.ppa) programmed in Microsoft® Visual Basic® for Application (VBA) that makes it possible to capture a number in Microsoft PowerPoint®, configure its respective SpellNumber (write-out number, as in check writing protection) through a popup user interface, and insert it back in PowerPoint or send it to the Microsoft Windows® clipboard to be immediately pasted into any PowerPoint place or into another Windows application.
It consists of only one file, the PowerPointSpellNumber.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 PowerPointSpellNumber.ini and PowerPointSpellNumber.ppam 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
- Captures number in the selection right-clicked by the mouse, through the SpellNumber command in popup shortcut menu
- If more than one number exists between text in the captured selection, 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 PowerPoint selection 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
- Four options exist for Spellnumber output: without brackets, between brackets; between brackets preceded by the corresponding number formatted according with the unit or vice versa
- Accepts the following hotkeys:
- Hotkey to popup:
Does not exist
- 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 PowerPoint 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 PPS duly converted to EXE by the PPtoEXE 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 PPS in PowerPoint without macro alert; (2) Extract the entire package to a folder and initiate the PPS, enabling the macros in PowerPoint, or (3) Install the DLL manually.
The COM add-in version available above to download is technically the best option because it consumes little PowerPoint memory and does not delay its load, but, if you’re a special PowerPoint user and prefer the add-in version (PowerPointSpellNumber.ppa) for some technical reason, I can make it available also with the same features as well as access to the source code all in VBA (standard modules and userforms). For this, it is necessary to become a special registered user. Click here to ask information about this special register.