Dear Friends, Help me to find formula in excel.
I want to transfer currency number of cell A1 into word format in cell B1.
e.g. If there is a number in 452 in cell A1. I want answer FOUR HUNDRED FIFTY TWO RUPESS IN CELL B1. How it possible.
Please help me as early as possible.
Jitendra Patel
Gujarat.
Mehsana/Gozaria
From India, Mahesana
28I want to transfer currency number of cell A1 into word format in cell B1.
e.g. If there is a number in 452 in cell A1. I want answer FOUR HUNDRED FIFTY TWO RUPESS IN CELL B1. How it possible.
Please help me as early as possible.
Jitendra Patel
Gujarat.
Mehsana/Gozaria
From India, Mahesana
Use 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.
[IMG]https://www.citehr.com/mk:@MSITStore:C:\Program%20Files\Microsoft%20Offic e\Office10\1033\xlmain10.chm::/images/blueup.gif[/IMG]How?
- Create a blank workbook or worksheet.
- Select the example in the Help topic. Do not select the row or column headers.
[IMG]https://www.citehr.com/mk:@MSITStore:C:\Program%20Files\Microsoft%20Offic e\Office10\1033\xlmain10.chm::/images/selecthelp.gif[/IMG] Selecting an example from Help - Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- 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
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Advanced Excel 2003.pdf
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Competancy--exc el---mts___smts _289.xls