Converting numbers to text

TSpradling · Mar 25th, 2002, 10:55 AM

I'm sure that this is a simple formatting issue, however I can't seem to find the correct format or function to utilize.

How to you convert numbers to text? Example is that of a check.
Amount equals $113.23

How do you format another cell to display "One hundred thirteen dollars and 23/100"

Thanks for your help, TS

Brian from Maui · Mar 25th, 2002, 11:00 AM

This will direct you to another address to convert numbers to text

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

TSpradling · Mar 26th, 2002, 05:17 PM

Brian,
Thanks for the tip on where to find my solution. I was able to paste in the formula into Visual Basic, and even tweak it to produce cents as a fraction of 100 instead of spelling it out. (ie, "46/100" instead of "forty six cents")

Next question on this topic. This works fine for the one spreadsheet that I pasted the procedure into. How can I make this global so that it's available in all of my workbooks? Or is there an easy was to activate it other spreadsheets? Thanks in advance

Brian from Maui · Mar 26th, 2002, 05:21 PM

TS,

Try this addin

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

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

Mar 25th, 2002, 10:55 AM	#1
TSpradling New Member Join Date: Mar 2002 Location: Fresno, CA USA Posts: 5	I'm sure that this is a simple formatting issue, however I can't seem to find the correct format or function to utilize. How to you convert numbers to text? Example is that of a check. Amount equals $113.23 How do you format another cell to display "One hundred thirteen dollars and 23/100" Thanks for your help, TS

Mar 25th, 2002, 11:00 AM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	This will direct you to another address to convert numbers to text http://www.mrexcel.com/board/viewtop...c=3036&forum=2

Mar 26th, 2002, 05:17 PM	#3
TSpradling New Member Join Date: Mar 2002 Location: Fresno, CA USA Posts: 5	Brian, Thanks for the tip on where to find my solution. I was able to paste in the formula into Visual Basic, and even tweak it to produce cents as a fraction of 100 instead of spelling it out. (ie, "46/100" instead of "forty six cents") Next question on this topic. This works fine for the one spreadsheet that I pasted the procedure into. How can I make this global so that it's available in all of my workbooks? Or is there an easy was to activate it other spreadsheets? Thanks in advance

Mar 26th, 2002, 05:21 PM	#4
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	TS, Try this addin http://www.mrexcel.com/board/viewtop...c=3266&forum=2