用EXCEl-打數字金額後 , 另一欄儲存格顯示英文字串是用什麼函數?
例如 :
$100.00 ONE HUNDRED ONLY.
EXCEL-數字金額用什麼函數顯示英文字串 .
2006-10-18 11:58 pm
回答 (2)
2006-10-19 6:51 pm
✔ 最佳答案
I answer this before.There is no install funciton to convert number to word. On the other hand, you can creat a user-defined function in VBA to do what you want. It is not diffcult. Go to the below website and it will teach you how to write the macro.
http://www.ozgrid.com/VBA/ValueToWords.htm
2006-10-19 12:06 am
以我所知excel應該無呢個function
收錄日期: 2021-04-23 14:13:20
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20061018000051KK01939