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
From India, Mahesana
Acknowledge(0)
Amend(0)
28Help 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
From India, Mahesana
Acknowledge(0)Amend(0)
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)
From India, Nagpur
Acknowledge(0)Amend(0)
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)
From India, Nagpur
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel function dictionary.xls