uk
English      
br
Português    
Other:

b POPUP SPELL NUMBER for Microsoft Excel

What's new   Download   Home  Ads

This utility 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 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 is programmed in Microsoft® Visual Basic® for Application (VBA) and optionally available as COM Add-in (dll), EXE Add-in (xla/exe), or Add-in (xla), may be useful for Excel interface user and VBA programmers. See the pictures below.

It consists basically of only one file (ExcelSpellNumber.dll, ExcelSpellNumber.exe, or ExcelSpellNumber.xla) that can be installed automatically using one of the installer package files available below to download. Except for the DLL, if you choose COM Add-in, no other setting is saved in the Windows Register. Its setting is saved in ExcelSpellNumber.ini, ExcelSpellNumberHotKey.xla, ExcelSpellNumberLoadExe.xla, and ExcelSpellNumber.xlam files that are created and maintained by the proper utility. You also can uninstall it 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)
$ 205.02 (two hundred five and 2/100 dollars)
$ 205.02 (two hundred five dollars and two pennies)
£ 205,02 (two hundred five pounds and two pence)
€ 205,02 (two hundred five euros and two cents)
P 206,02 (two hundred six pesos and two centavos only)
206,02 (two hundred six and 02/100 only)
205,02 % (two hundred five point zero two per cent)
205.02 g (two hundred five gallons and two hundredths of gallon)
205.02 (two hundred five, and two hundredths) - Pure number, no unit

Following items in this page:

Features

Download

Add-in Options to Install

Pictures

fSpellNumber() Sheet Function

Features:

- 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
- Hotkey to insert over selection: O
- Hotkey to insert right of selection: R
- Hotkey to insert left of selection: L
- Hotkey to insert down of selection: D
- Hotkey to insert up of selection: U
- Hotkey to copy to Windows Clipboard: C
- The Enter key is a special insertion hotkey. Its action varies according with output format option. If the output is set as the number in addition to its SpellNumber, the Enter key will insert it over the selection. If the output is a formula, the enter key will copy it to Windows Clipboard. Otherwise, it will insert to the right of the selection

- 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)
The smallest sensitive fraction: 1 trillionth (0.000,000,000,001)
The number or numbers captured are listed as suggestions in the ComboBox and the first is the default

- Unit Singular ComboBox: Unit name entry in the singular.

Default: Dollar
Empty denotes pure number
The suggestion list of unit names where the first is default can be edited and saved by the user.

- 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):

1 - Spells the fraction in cent/cents. Ideal for coins
2 - Spells decimal point, each zero and the rest of the number as an integer. Ideal for percents
3 - Spells the fraction in tenths to trillionths. Ideal for pure numbers
4 - Doesn't spell the fraction but writes it as a fraction with denominator of 100, 1000, 1000000... Ideal for coins when in fractions lesser than one cent, or even in cents, although option 1 occurs about ten times more frequently
5 - Idem adding 'Only' at the end. Ideal for coins
6 - Spells the fraction in penny/pennies. Ideal for coins
7 - Spells the fraction in penny/pence. Ideal for coins
8 - Spells the fraction in centavo/centavos only. 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
2 - Sentence case (Only the 1º is upper)
3 - Title Case (1º Upper in Each Word)
4 - ALL UPPER 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').
Default: True

- Thousand comma ComboBox: Entry of the options for comma intercalation between thousand or not:

True (Yes) or False (Not);
Default: False (without intercalation).

- 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).

- Sound

- Occupies less than 150 Kb when installed.

Download:

Tested in Excel for Windows, versions 2000, 2002(XP), 2003, 2007, 2010 (32 and 64-bit), 2013 (32 and 64-bit), 2016 (32 and 64-bit), and 2019 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365™ cloud-based services.

Download

Download the English version here   
You also can download from this mirror site   
Last update: 12/23/2023 - 1621.2kb    
Freeware based in this License Agreement   

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.

See also for Microsoft Access®, for Microsoft PowerPoint®, for Microsoft Word, and, if you develop in VBA, fSpellNumber() function source code.

Add-in Options to Install:

This utility can be available to be installed in three options of add-ins: EXE Add-in, COM Add-in, or Excel Add-in. COM Add-in and Excel Add-in run on Windows in the same process or memory space of Excel and are well detailed technologies in Excel documentation and good books about VBA, while EXE Add-in is a special name here for a mix of those two technologies where the same VBA code is run in separate EXE process and a small Excel Add-in makes the connection between the two processes. Despite the differences in the technologies, this utility is fully functional in any of them. So, what can decide on your choice to install are the features below compared:

Features / Add-in Options

 EXE Add-in

 COM Add-in

 Excel Add-in

- Availability in this package:

Yes

Yes

No¹

- Requires rights elevation in Windows:

No

Yes No

- Excel 64-bit supportability:

Yes

No Yes

- Performance in the load:

Great

Great Poor

- Performance in the functionalities:

Good/great

Great Great

- Interference in the Excel performance:

Very Little

Little Medium

- Risk of Excel crash:

Very Low

Low Medium

- Main file extension:

xla/exe

dll xla

¹Temporarily unavailable.

Pictures:

Picture

fSpellNumber() Sheet Function:

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.

- Arguments:

1º) Num - The cardinal number with or without fraction to spell out
The largest valid number: 1 trillion minus 0.01 (999,999,999,999.99)
The smallest sensitive fraction: 1 trillionth (0.000,000,000,001).

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):

1 - Spells the fraction in cent/cents. Ideal for coin
2 - Spells decimal point, each zero and the rest of the number as integer. Ideal for percent
3 - Spells the fraction in tenths to trillionths. Ideal for pure number
4 - Doesn't spell the fraction but writes it as a fraction with denominator of 100, 1000, 1000000... Ideal for coin when in fractions lesser than one cent or even in cents although 1 option is about ten times more frequent
5 - Spells the fraction in penny/pennies. Ideal for coin
6 - Spells the fraction in penny/pence. Ideal for coin in UK
7 - Spells the fraction in centavo/centavos only. Ideal for coin in Philippine.

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
2 - Sentence case (Only the 1º is upper)
3 - Title Case (1º Upper in Each Word)
4 - ALL UPPER CASE.

- Examples:

You 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:
= fSpellNumber(A1, 1, "Dollar").

 

More information

Home

 

Facebook



gplus

 

 

Visitas acumuladas em todas as páginas:
Visitas hoje só nesta página: