Formula developed by CA to convert number to words - Num2Txt

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".
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"
The formula "Num2Txt" is available within tool named "fxFix". "fxFix" is a "Formula (fx) Fixing Tool" that provides various formulas that dont exist in Excel. To download "fxFix" click here.
 
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 CA Vikram Verma
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

 

Replies (1)
Bro plz send these type of things to my mail id too rajangoyal08 @ gmail. com

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details