number to words

vivekshanghvi

New Member
Joined
Sep 14, 2006
Messages
20
any idea how to convert a given number into words?
eg
45000.65
to forty five thousand and sixty five cents only
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good morning vivekshanghvi

There is a macro here that will do what you require giving the result in dollars / cents :

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360

If you don't fancy using the macro, you can download my add in from the link below which has a custom written function which, when installed can give the result in USD, GBP, EUR, INR or none. The syntax you would use would be :

=SPELLNUMBER(A1,"USD")

HTH

DominicB
 

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Hi garymu16

Not that I'm aware of. It would be a lot more difficult the other way round because you would try and extract whole words (not single digit numbers) and there are different ways of writing the numbers (Americans tend to use "one hundred fourteen", British would use "one hundred and fourteen") there are also various commas (or not to contend with). In addition to this, the numbers to words question comes up often, but rarely the other way around.

If you find one please feel free to post it.

DominicB
 

Watch MrExcel Video

Forum statistics

Threads
1,108,922
Messages
5,525,647
Members
409,658
Latest member
Yardcell

This Week's Hot Topics

Top