[求助] 有金额英语大写的函数吗!高手帮忙!

zjqinlian

<p>A1=USD</p><p>A2=55024.42A3自动生成SAY TOTAL&nbsp; U.S.DOLLARS FIFTY-FIVE THOUSAND&nbsp; AND TWENTY-FOUR AND CENTS FORTY-TWO ONLY</p><p>请高人指点!</p>

shizx98

<p>论坛搜索一下有解答的。</p><p>或者参考<span lang="EN-US" style="FONT-SIZE: 10.5pt; COLOR: fuchsia; FONT-FAMILY: &quot;Times New Roman&quot;; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><a href="http://www.excelpx.com/dispbbs.asp?boardID=92&amp;ID=15883&amp;page=1">http://www.excelpx.com/dispbbs.asp?boardID=92&amp;ID=15883&amp;page=1</a></span></p>