提示:其他語言是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:比200方便的Excel加載項,可以在60天免費試用。 下載並免費試用現在!


生產力推薦工具
以下工具可以大大節省您的時間和金錢,哪一個適合您?
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 · 4 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