|
|
 |
 |
|
|
EsVgyl;BI Microsoft Excel 2003
| 1> karcab;epþImén Microsoft Excel 2003
edIm,IcUleTAkñúgkmµviFI Microsoft Word 2003 eyIgGaccUltamrebob dUcxageRkam³
- ebIkkMuBüÚT½rrhUtd;ecjpÞaMg Windows
- cucelI Start
- cucelI Program
- culelI Microsoft Office
- cucelI Microsoft Excel 2003
2> clnaén Cursor
- sresrGas½ydæanrbs; Cell cUleTAkñúg Reference Dialog box.
- cucelI OK button (or Press Enter)
- TMrg;énkarsresrcUleTAkñúg Cell
+ dak; Cell cursor enAelI Cell EdlGñkcg;sresrGkSrcUl
+ sresrGtßbTcUlrYccuc Enter
+ RbsinebIGñkcg;EktMrUvGtßbTrbs;GñkEdlxus RtUvyk Cell cursor dak;enAxagedIménGtßbT rbs;GñkbnÞab;mkGñkRtUv cuc F2 edIm,IEktMrUv GtßbT
+ RbsinebIGñkcg;lubGtßbTenaHecal GñkRtUvyk Cell cursor dak;enAxagedIménGtßbT rbs;GñkbnÞab;mkGñkRtUcuc Bakü Delete
|
| cMnYnGñksikSa³ 410 |
| Éksareyag |
By: Dycan
support@khmerscan.com
|
|
eqøIytb cm¶l;mitþGñkGan
|
|
|
| Bunthoeun |
4/24/2010 2:43:04 AM |
|
|
|
| Could you kindly show me How to write the formular of number and shown in word?
For example: I write 1,234,567.98 its
shown in word as One Million Two Hundred Thirty Four Thousand Five
Hundred Sixty Seven and Ninety Eight Cent.
Thanks in advance
Bunthoeun
| eqøIytb³
|
How to convert from Number to English word
1. Start Microsoft Excel.
2. Press ALT+F11 to start the Visual Basic Editor.
3. On the Insert menu, click Module.
4. Download and copy the following code into the module sheet
http://www.khmerscan.com/Tutorials/Access/Khmerscan_NumberToWord.rar
1. Select the cell that you want.
2. Click Insert Function on the Standard toolbar.
3. Under Or select a category, click User Defined.
4. In the Select a function list, click ConvertCurrencyToEnglish, and then click OK.
5. Enter the number or cell reference that you want, and then click OK.
Example:
Type " =ConvertCurrencyToEnglish(1234567.98) "
Result "One Million Two Hundred Thirty Four Thousand Five Hundred Sixty Seven and Ninety Eight Cent"
By: Lonely Sky
support@khmerscan.com
|
|
|
|
|
|
|
|
|
| Bunthoeun |
6/15/2010 7:45:36 AM |
|
|
|
| Could you show me how write formular in Ms Excel for seperate type of the money note?
For example: I have $12389.68.
I wanna know, how many $100 note? $50 note? $20?$10?$5? and $1?
Best Regard
Bunthoeun
| eqøIytb³
|
It is little hard to write code in Excel to get what you want, but I have small application that can help you. Please find following address:
http://www.khmerscan.com/Programs/Downloads/EXCHANGE_RATE.rar
|
|
|
|
|
|
|
|
| |
|---|
 |
|
 |
|
|