Convert Number value in text string
I am using Microsoft Excel 2007.I want automatic conversion of a number value into relative text string.It means if I have "687" into one cell, then it should be converted into "Six hundred and eighty seven" into next cell.Pl. guide me for this.
Software/Hardware used:
Software/Hardware used:
ASKED:
September 20, 2008 3:52 PM
UPDATED:
September 22, 2008 4:35 PM
RELATED QUESTIONS
- Convert from text to number - exporting to Excel 2003 from SQL Reporting Services 2008 R2
- Convert formula result string to number
- How to convert a "Numeric-String" with '-' sign and decimal places into pure "Numeric"?
- VBS - Taking input from one spreadsheet and output to another
- How to accept user input and display the value in Excel 2007 macros
Answer Wiki:
This <a href="http://www.ozgrid.com/VBA/ValueToWords.htm">Site</a> contains instructions on how top do what you want to do. This <a href="http://excel-convert-numbers-to-text-software.sobolsoft.qarchive.org/">Site</a> has a type of plug in that seems to also do what you are asking. Remember in the case of download ANY software, check with a good anti virus program, and test on a network isolated machine before putting it into general use.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
