Expressing a number as a string of text

Drew · Feb 20th, 2002, 01:27 PM

Is there a way to enter a number, for example 35,231.00, and create the following text "thirty five thousand two hundred thirty one"?

I tried to search the archives because I seem to remember someone asking a similar question. (couldn't find it though)

Thanks in advance.
Great site.
Drew

Juan Pablo González · Feb 20th, 2002, 01:32 PM

Here is that question (And Barrie's answer)

http://www.mrexcel.com/wwwboard/messages/23156.html

Drew · Feb 20th, 2002, 02:14 PM

Thanks Juan. Exactly what I needed.

Drew

Feb 20th, 2002, 01:32 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Here is that question (And Barrie's answer) http://www.mrexcel.com/wwwboard/messages/23156.html __________________ Regards, Juan Pablo González http://www.juanpg.com

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

Feb 20th, 2002, 01:27 PM	#1
Drew Board Regular Join Date: Feb 2002 Location: Boston, Mass Posts: 169	Is there a way to enter a number, for example 35,231.00, and create the following text "thirty five thousand two hundred thirty one"? I tried to search the archives because I seem to remember someone asking a similar question. (couldn't find it though) Thanks in advance. Great site. Drew

Feb 20th, 2002, 02:14 PM	#3
Drew Board Regular Join Date: Feb 2002 Location: Boston, Mass Posts: 169	Thanks Juan. Exactly what I needed. Drew