Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I convert digits to alpha text?
I want to take a numerical value in a cell of Excel and use it in a form
which calls for the value to be in alpha text. ie. $125.00 should be converted to: One hundred twenty-five dollars and 00/100 |
#2
|
|||
|
|||
Hi Richard,
See http://www.mvps.org/dmcritchie/excel...numberstowords for some links. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Richard Selzer" <Richard wrote in message ... I want to take a numerical value in a cell of Excel and use it in a form which calls for the value to be in alpha text. ie. $125.00 should be converted to: One hundred twenty-five dollars and 00/100 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert dollars and cents to text, and prefill the cell . | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions | |||
How to convert Numbers to text | Excel Worksheet Functions |