Value to Text

tum_99 · May 8th, 2002, 07:59 PM

I am looking for a function which can convert/translate the value into text. For example, if I have a value "1000" in cell A1 then I would it to display "one thousand dollar" in cell B1. Can anyone suggest me how to do it automatically as I have to do it manually in thousand of cells.

Brian from Maui · May 8th, 2002, 08:39 PM

Try this thread

http://www.mrexcel.com/board/viewtop...c=7289&forum=2

tum_99 · May 8th, 2002, 09:22 PM

Thank you. On My computer "SpellNumber" function does not work. Do you know why? But the other example works.

Chris Davison · May 10th, 2002, 07:12 PM

Tum,

it's a user-defined function, not an in-built one...

if you scroll down on that sheet, it gives you the code you need to enter in your VBA module thingy before it will work by just typing =SPELLNUMBER

if you follow the link in Aladin's suggestion, it has an addin that has already done all this for you (and a whole lot more), which I personally think is more convenient

anyhow,

May 10th, 2002, 07:12 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Tum, it's a user-defined function, not an in-built one... if you scroll down on that sheet, it gives you the code you need to enter in your VBA module thingy before it will work by just typing =SPELLNUMBER if you follow the link in Aladin's suggestion, it has an addin that has already done all this for you (and a whole lot more), which I personally think is more convenient anyhow, __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 07:59 PM	#1
tum_99 New Member Join Date: May 2002 Posts: 2	I am looking for a function which can convert/translate the value into text. For example, if I have a value "1000" in cell A1 then I would it to display "one thousand dollar" in cell B1. Can anyone suggest me how to do it automatically as I have to do it manually in thousand of cells.

May 8th, 2002, 08:39 PM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Try this thread http://www.mrexcel.com/board/viewtop...c=7289&forum=2

May 8th, 2002, 09:22 PM	#3
tum_99 New Member Join Date: May 2002 Posts: 2	Thank you. On My computer "SpellNumber" function does not work. Do you know why? But the other example works.