www.excelolozy.com is developed by a CA that offers multiutility tools for Finance professionals.
On top of all it never does any pop-updates as other softwares do.
To convert Number, values or digits to Text is easy through "Num2txt" formula. 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".
- 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"
Full post is here:
https://www.excelolozy.com/2012/07/how-to-convert-number-to-text-through.html
Anything in Excel, be an Excelolozian...
for best MS Excel Tips visit https://www.Excelolozy.com
gotta query??? drop a mail at mail @ excelolozy.com
 |
| 10 Alone quote by Vikrmn : You are born the day you find yourself. |
"You are born the day you find yourself."
EXCERPTS: 10 Alone
<>
***
10 Alone
a Saga of 10 Friends.. story of 10 Chartered Accountants,
www.10Alone.com
Novel Authored by Vikrmn: (CA Vikram Verma)
www.Vikrmn.com
EXCERPTS: 10 Alone
<
***
10 Alone
a Saga of 10 Friends.. story of 10 Chartered Accountants,
www.10Alone.com
Novel Authored by Vikrmn: (CA Vikram Verma)
www.Vikrmn.com
CAclubindia
