提示:其它语言是由 Google 机器翻译的。 你可以访问 English 版本。
登录
x
or
x
x
马上登记
x

or

在Excel中快速转换或拼出一个数字为英文单词

在Excel中,您可能需要将数字值(数字)转换或拼写成英文单词,例如转换 100.25 成英文单词“一百美元二十五美分”。 除了使用VBA代码在Excel中解决它之外,没有有效的功能。 但是 Kutools for Excel数字到货币词,你可以快速将数字转换成英文单词或中文单词。


点击 Kutools >> 内容 >> 数字到单词,看截图:

射击法术数字1


用法:

1。 突出显示您想要将数字拼写成英文拼写(单词或文本)的范围。

2。 单击应用该实用程序 Kutools > 内容 > 数字到单词,然后在对话框中指定语言。 有一个内置的预览窗格让你立即看到结果。 看截图:

射击法术数字1

3。 然后点击 OK or 申请。 所有的数字都被转换成了英文单词。 查看截图:

射击法术数字1


演示:将数字拼写成英文或中文单词


Kutools for Excel 包含多个用于Excel的300便捷工具,可以在30天内不受限制地免费试用。 立即下载并免费试用!

生产力推荐工具
以下工具可以大大节省您的时间和金钱,哪一个适合您?
Office Tab: 在您的Office中使用方便的选项卡,作为Chrome,Firefox和新Internet Explorer的方式。
Kutools for Excel: Excel的300高级函数 2019,2016,2013,2010,2007和Office 365。
Classic Menu for Office: 把熟悉的菜单带回到Office 2007,2010,2013,2016,2019和365,就像它是Office 2000和2003一样。

Kutools for Excel

上述功能只是Kutools for Excel的300强大功能之一。

专为Excel(Office)2019,2016,2013,2010,2007和Office 365而设计。 免费下载并使用60天。

Excel的Kutools屏幕截图

BTN阅读更多 BTN下载 btn购买

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Yarosh · 5 months ago
    Cześć! W ostatnich latach, jest on niewątpliwie wpływa wejście informacyjnych. Według tego tematu, działa przedsiębiorstwo jest drażliwy temat, który ma znaczną władzę na impuls firmy. Polecam do zbadania dalszych okoliczności, zanim zaczęła się zmieniać głównego systemu. Poszukaj korzystania z cyfryzacji służbowe, na przykład elektroniczny pokojowej danych online dokumentalnym, w chmurze lub komunikacji korporacyjnej w Internecie. Wystarczy poszukać nowych możliwości. I awansować określić z VDR miękkich np virtual deal room.
  • To post as a guest, your comment is unpublished.
    Daniël · 2 years ago
    Please make the following corrections to the webpage (read: website) and the Kutools Add-in: numbers twenty-one (21) through ninety-nine (99) are hyphenated when spelled.
    • To post as a guest, your comment is unpublished.
      Qiu hongkun · 2 years ago
      Hello,

      Do you mean the 21 should be spelled as twenty-one and 99 should be spelled as ninety-nine? :)

      Thanks in advance.
  • To post as a guest, your comment is unpublished.
    Shiv Kumar · 2 years ago
    Hey, I am from India and need to Spell Out Numbers in words in Indian Rupee Format. Please help as it shows only in dollars . Make it convenient for individual currencies.
  • To post as a guest, your comment is unpublished.
    Javed · 2 years ago
    I need to convert PKR and USD in numbers into word, please help in excel or ad-on
  • To post as a guest, your comment is unpublished.
    shashi · 2 years ago
    how to to convert numbers in value. please help
  • To post as a guest, your comment is unpublished.
    arun · 2 years ago
    how to convert numeric value into words
  • To post as a guest, your comment is unpublished.
    kellie · 2 years ago
    your VBA code for Spellnumber gives a syntax error
  • To post as a guest, your comment is unpublished.
    SAFDER · 2 years ago
    Sir

    I need excel formula for convert Pak Rupees numbers into Word.

    Regards
  • To post as a guest, your comment is unpublished.
    ashfaq · 5 years ago
    Sir i need this format VBA for Rial omani currency.
    15.562 Fifteen Rials & five hundred sixty two Baisas only
    pls help me on this....
  • To post as a guest, your comment is unpublished.
    Bharat · 5 years ago
    Is there any way to convert number in INR in excel 2007 without using macros or vba. as by using same i am not able to merge the same with MS Word for preparing letters.
    Any help would be appreciable.
  • To post as a guest, your comment is unpublished.
    suresh · 5 years ago
    how to convert word to number in excel 2007 and 2010
  • To post as a guest, your comment is unpublished.
    chandra has pardhi · 5 years ago
    number change to word formula in Excel
  • To post as a guest, your comment is unpublished.
    nasih · 5 years ago
    need to change the numeric number to text
    eg. 32.5 to in another cell in text format thirty doller two fifty cent