How Can I Convert Numbers to Words in Excel for Currency Formatting?

Dear Friends,

Help me find a formula in Excel. I want to transfer the currency number from cell A1 into word format in cell B1. For example, if there is the number 452 in cell A1, I want the answer to be "FOUR HUNDRED FIFTY-TWO RUPEES" in cell B1. How is this possible? Please assist me as soon as possible.

Jitendra Patel
Gujarat, Mehsana/Gozaria

Use the BAHTTEXT formula and read the following instructions:

Converts a number to Thai text and adds a suffix of "Baht."
In Microsoft Excel for Windows, you can change the Baht format to a different style by using Regional Settings or Regional Options in Control Panel.
In Excel for the Macintosh, you can change the Baht number format to a different style by using Control Panel for Numbers.

Syntax
BAHTTEXT(number)
Number is a number you want to convert to text, or a reference to a cell containing a number, or a formula that evaluates to a number.

Example
The example may be easier to understand if you copy it to a blank worksheet. How?

1. Create a blank workbook or worksheet.
2. Select the example in the Help topic. Do not select the row or column headers. Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

12AData1234FormulaDescription (Result)=BAHTTEXT(A2)Displays the number in text. (One thousand two hundred thirty-four Baht in Thai text)