Convert number into text in excel

7128 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)

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 24 June 2026
CA Article Trainee

Rahul Dang & Associates

Pune

CA Inter

View Details
Company
ARTICLESHIP 16 July 2026
Article Assistant

G A R U D & Associates

New Delhi

CA Inter

View Details
Company
Featured 16 July 2026
Semi Qualified Company Secretary

Vakilsearch.com

Chennai

CS

View Details
Company
Featured 24 June 2026
HEAD - AUDIT AND TAXATION

A R JADHAV AND ASSOCIATES

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 20 June 2026
Articleship

RB KESHRI & CO

Mumbai

B.Com

View Details
Company
13 July 2026
AVP / VP - PCG Advisory

Workforce Connect

Mumbai

MBA

View Details
Company
20 June 2026
Assistant Accounts Manager

Fintax Professionals

Gurgaon

CA Inter

View Details
Company
ARTICLESHIP 10 July 2026
Article Assistant

N S Gokhale & Co

Thane

CA Inter

View Details