Hi everyone I need to translate numbers into letters using an excel macro.
Any idea on how to do so?

Assuming you have complete freedom in the choice of letters, use Roman
Numerals:


if A1 contains 10, then ROMAN(A1) would show X
--
Gary's Student


"Albert" wrote:

Hi everyone I need to translate numbers into letters using an excel macro.
Any idea on how to do so?

"Albert" wrote:

Hi everyone I need to translate numbers into letters using an excel macro.
Any idea on how to do so?

Hi I appreciate the help, but what I meant was how to turn a number (EJ 100)
into letters (One hundred), sorry if I didn´t make myself clear

No problem at all. This is a common request. See:


XL: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default...N-US;q140704&;


--
Gary's Student


"Albert" wrote:



"Albert" wrote:

Hi everyone I need to translate numbers into letters using an excel macro.
Any idea on how to do so?

Hi I appreciate the help, but what I meant was how to turn a number (EJ 100)
into letters (One hundred), sorry if I didn´t make myself clear

--------------------------------------------------------------------------------
http://au.geocities.com/excelmarksway

Click the Converters Button

How it works:

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:
999 million + 1 = One Billion
999 Billion + 1 = One Trillion
One Trillion = 1,000,000,000,000
One Billion = 1,000,000,000
One Million= 1,000,000
One Thousand = 1,000
One Hundred = 100
Ten = 10
Zero = 0
The code is written in long-hand.
Written by Mark E. Philpot March 2006 Copyright,
NumberWordConversion.xls


----------------------------------------------------
"Albert" wrote:

Hi everyone I need to translate numbers into letters using an excel macro.
Any idea on how to do so?