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