Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

Convert number into text in excel

Rachana Gadage (Account Executive) (136 Points)

12 October 2007

Can anybody tell me a formula for converting number into text format in Excel.

e.r.12000 output should be

Rs. Twelve Thousand Only

Reply
Follow
Share

21 Replies

madhukar dodrajka (service) (28 Points)
Replied 12 October 2007

https://support.microsoft.com/kb/213360

Upgrade to CAclubindia Pro. Subscribe Now!

(Guest)

Rachana Download this small utility from our share file section

/files_display.asp?files_id=1856

Rachana Gadage (Account Executive) (136 Points)
Replied 12 October 2007

hi rakesh thank you very much

(Guest)

There is nothing in excel to convert no. into excel except one function of =BAHTTEXT but not in eglish. you have to make program in macro

Rachana Gadage (Account Executive) (136 Points)
Replied 12 October 2007

Deepak If u download the utility which is mentioned by rakesh then u will get proper output Try it it is really helpfull

Upgrade to CAclubindia Pro. Subscribe Now!

siddharth (C.A.) (175 Points)
Replied 12 October 2007

Hi, For this type of conversion u wiil have to visit website www.asap- utilities.com and download the toolbar. After Downloading, Go to option numbers and select spell number. if u still dont get it let me know. regards Siddharth

(Guest)

i have excel file but you can use without my permission. you can see results

jitan (Service) (33 Points)
Replied 12 October 2007

I also need similar help

Vijay Patnaik (Management Consulting) (287 Points)
Replied 15 October 2007

I have the EXCEL file which can convert and show numbers in Ruppes upto 99 crores. (Some other files give only number or text in Dollars).

Give you email IDs I will email directly with instructions.

siddharth (C.A.) (175 Points)
Replied 16 October 2007

Hi Vijay, Can u pls mail me the file on siddharthdoshi @ rediffmail.com. Thnx in advance

Upgrade to CAclubindia Pro. Subscribe Now!

balwant (Service) (86 Points)
Replied 12 June 2008

need formula for converting no. value in Text

Rs. 100 As One hundred only.

Is it posible in ecel.

(Guest)

Here is the attched file helps you to covert numaric value in alphabet. pls go to Toos> Macro>visual basic editor and copy the matter in your excel file's Visual basic then it will work

Attached File : 1 words.xls downloaded: 411 times