www.excelolozy.com - To convert Number, values or digits to Text is easy through "Num2txt" formula.
This formula converts any number or digit as follows :
More over this formula has also option of showing prefix and suffix to the resulting text.
"formulaFix" is a "Formula Fixing Tool" that provides various formulas that dont exist in Excel.
To download "formulaFix" click here.
This formula converts any number or digit as follows :
- e.g. to convert 2,735 to text following is the solution:=Num2txt(2735) result of which is shown as "Two Thousand Seven Hundred Thirty Five".
More over this formula has also option of showing prefix and suffix to the resulting text.
- e.g. to prefix "INR" to above example:=Num2txt(2735,"INR") result of which is shown as "INR Two Thousand Seven Hundred Thirty Five"
- e.g. to suffix "only" to above example:=Num2txt(2735,"INR","only") result of which is shown as "INR Two Thousand Seven Hundred Thirty Five only"
"formulaFix" is a "Formula Fixing Tool" that provides various formulas that dont exist in Excel.
To download "formulaFix" click here.
Anything in Excel, be an Excelolozian...
for best MS Excel Tips visit http://www.Excelolozy.com
gotta query??? drop a mail at mail@excelolozy.com