Convert number into text in excel

6938 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
"


 

Replies (21)
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