| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Is there a function to change a number to text?
I am trying to find a function that will convert numbers to text. For example: the function will convert $567.87 to Five Hundred Sixty Seven and 87/100's. Anybody know how to do this? -- psdunlavy ------------------------------------------------------------------------ psdunlavy's Profile: http://www.msusenet.com/member.php?userid=2120 View this thread: http://www.msusenet.com/t-1870524589 |
|
#2
|
|||
|
|||
|
Take a look he
http://www.mvps.org/dmcritchie/excel...numberstowords In article , psdunlavy wrote: I am trying to find a function that will convert numbers to text. For example: the function will convert $567.87 to Five Hundred Sixty Seven and 87/100's. Anybody know how to do this? |
|
#3
|
|||
|
|||
|
Good evening psdunlavy There seems to be quite a demand for this type of function, although Excel doesn't actually do it as a native function. Some add-ins are available that once installed will do this (amongst other things) - to receive my add-in (free to anyone who e-mails me), with instructions on how to use the function, please send an e-mail to . HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=377898 |
|
#4
|
|||
|
|||
|
This file might be a help:
http://www.bygsoftware.com/examples/...s/num2wrds.zip It's in the "Accountants" section on page: http://www.bygsoftware.com/examples/examples.htm It contains the "SPELLNUMBER" function, which can be used in your spreadsheets, two methods to convert numbers to words and two cheque writing routines. The code is open and commented. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "psdunlavy" wrote in message ... I am trying to find a function that will convert numbers to text. For example: the function will convert $567.87 to Five Hundred Sixty Seven and 87/100's. Anybody know how to do this? -- psdunlavy ------------------------------------------------------------------------ psdunlavy's Profile: http://www.msusenet.com/member.php?userid=2120 View this thread: http://www.msusenet.com/t-1870524589 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making a number be text | Excel Worksheet Functions | |||
| Using Excel converts number to english text | Excel Worksheet Functions | |||
| How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
| How do I change a text fraction. eg 1 1/2 into a decimal number, . | Excel Worksheet Functions | |||
| The number change from 1350 to 13.5 and Enter does not function properly | Excel Discussion (Misc queries) | |||
Linear Mode
