Convert number into text in excel

Page no : 2
(Guest)
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
"


 


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


(Guest)

12050


(Guest)

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


(Guest)

how i can convert fugure in words in excel



Prabeer (B. COM (H) CA & CS Final)   (5484 Points)
Replied 15 November 2008

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...


Attached File : 30 rswordsaddin.zip downloaded: 298 times

Akash (Accountant) (66 Points)
Replied 18 January 2011

=spellrupee( adress of number cell)



Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Join CCI Pro


Subscribe to the latest topics :

Search Forum: