Dear All

I want to convert number into text. Suppose A cell has (250) figures of amount in Rupees. Next cell should display as (Two Hundres fifty rupees only)

I used function BAHTTEXT but it convert in Thai Language.

Regards.

Wasim

Hello Wasim,

Here are 3 different options for you:

1. You can download and install ASAP Utilities
ASAP Utilities - Numbers » Spell/write out numbers or amounts (EN, DE, NL)... - List of tools - Excel software

2. You can write a VBA UDF, examples:
How to convert a numeric value into English words in Excel
VBA Express : Multiple Apps - Change number into complete words, including currency names

3. You can use a formula-driven approach; there is an example you can download and adapt from MS MVP Debra Dalgleish's site:
http://www.contextures.com/NumsToWords_No_VBA.zip

Hope that helps...
Colin