banner_ad

Convert number into text in excel

7064 views 21 replies
Originally posted by :Rachana Gadage
" hi
Can anybody tell me a formula for converting number into text format in Excel.
e.r.12000 output should be
Rs. Twelve Thousand Only
"


 

Originally posted by :Guest
" need  formula for converting no. value in Text
Rs. 100   As One hundred only.
Is it posible in ecel.
 
 
"

12050

i want to convert number into text e.g.

1256= one thousand two hundred fifty six

can any body tell me how it possible in excel

how i can convert fugure in words in excel

Mr. Nitin U just have 2 install the addin 2 ur office pack which is attached here.

Then u have 2 go 2 any cell and write =rswords(select the number u want 2 write in words)

Try...

=spellrupee( adress of number cell)


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 02 May 2026
Senior Executive

hitesh chandwani & co

Pune

B.Com

View Details
Company
Featured 29 April 2026
Manager- Finance and Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured ARTICLESHIP 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details