|
|
FormatNum |
|
|
2000.05.06 |
http://www.tandb.com.au/appleworks/formatnum/ |
|
|
Description |
This “FormatNum” AppleWorks function script translates a numeric formula result into the equivalent text string. |
|
|
Scripts |
See the scripts page for general installation and usage information. |
|
|
by Neil Taylor |
This script was not developed by T&B. Contact the author directly with any questions and feedback. |
|
|
Download |
Download the script from here. |
|
Detail
FormatNum is a function script that takes a numeric formula and returns that number as the text version.Samples
It takes the form:-
=MACRO("Formatnum",2,"astext", formula)
Formula is any formula which returns a numeric value. The function will return a text string containing the wordy form of the number.
If a formula calculates out to 123456.789 the MACRO("Formatnum" ...) function script will return: “one hundred twenty three thousand, four hundred fifty six point 789”.Limitations
More examples:
input
MACRO("Formatnum",2,"astext", input+0) 10 ten 25000.56 twenty five thousand, point 56 47 fourty seven 100000000 one hundred million 200000094 two hundred million, ninety four Zero
Numbers above a quadrillion (1,000,000,000) will not be calculated. “Formula” cannot be just a cell number (limitation of AppleWorks 5.0) it must be a formula. The workaround for it is to, for example, add zero (A1+0 instead of just A1).Requirements
This script works with AppleWorks 5. It has not been tested with AppleWorks 6.© 2000 T&B
