MacroSoftly Member " MEP " - Macro Entry Person.
Converters:
Utilities that convert things from one unit type to another unit type.
NumberWordConversion:
Click a Cell to evaluate or type the word number (or integer number) into the Textbox. If it is a Cell Value then click the "Cell Contents" button else click the "Textbox Contents" button to setup the number context. If it is a word number to integer (one thousand to 1,000) then Click the Right Arrow Button. If it is an integer number to a word number (1,000 to one thousand) then Click the Left Arrow Button. Only one button will be enabled, anyhow.
Currency or regular numbers are acceptable. Also, the Currency type accepted is: Dollars, Pounds, Euros, Yen, or None. Funny numbers, mixed words/numbers (one hundred dollars and 00/100) etc are not acceptable and will either not be converted or the results may not be what is expected. The maximum number is 999,999,999,999,999.99 and the minimum number is 0. Negatives are read as a postive number.
There are variations in different countries on what determines a Trillion or Billion. The following shows the determination of this Utility:
  1. 999 million + 1 = One Billion
  2. 999 Billion + 1 = One Trillion
  1. One Trillion = 1,000,000,000,000
  2. One Billion = 1,000,000,000
  3. One Million= 1,000,000
  4. One Thousand = 1,000
  5. One Hundred = 100
  6. Ten = 10
  7. Zero = 0
The code is written in long-hand.
Written by Mark E. Philpot March 2006 Copyright, excelmarksway@yahoo.com.au NumberWordConversion.xls
1