在excel中，打入數字，可否轉為英文 and/or 打入英文，轉為數字呢?
例如 : 在 A1 打 $500.00, 會出現Five hundred dollars only.
又例如 : 在 A1 打 Four hundred dollars only，會出現 $400.00
請幫忙！Thanks!
Excel 問題！
2008-04-16 5:07 pm
回答 (3)
2008-04-17 7:25 pm
✔ 最佳答案
你不應用 [ Excel 問題！] 問, 應以 [ 英文轉為數字 ] 去搜尋就找到答案如下
http://hk.knowledge.yahoo.com/question/question?qid=7006061203553
2008-04-16 5:39 pm
Not, it is not possible
2008-04-16 5:29 pm
I am afraid not. It is possible if and only if you set a serise of formula and/or marco.
Would you mind to specify your need, so I may be able to address you the right formula/setting/marco. e.g why do you need that and when will you account the above problem.
2008-04-17 12:59:08 補充：
Please do not say "not possible" when you are familiar to excel. I can make an excel file to convert serise of numric to chinese character numric with using formula and reference only.
Would you mind to specify your need, so I may be able to address you the right formula/setting/marco. e.g why do you need that and when will you account the above problem.
2008-04-17 12:59:08 補充：
Please do not say "not possible" when you are familiar to excel. I can make an excel file to convert serise of numric to chinese character numric with using formula and reference only.
收錄日期: 2021-04-23 19:29:06
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080416000051KK00420