Suggerimento: le altre lingue sono tradotte da Google. Puoi visitare il English versione di questo link.
Accedi
x
or
x
x
Registrati
x

or

Converti o scrivi velocemente un numero in parole inglesi in Excel

In Excel, potrebbe essere necessario convertire o specificare un valore numerico (un numero) in parole inglesi, ad esempio per convertire 100.25 in inglese parole "Cento dollari e venticinque centesimi”. Non esiste una funzione efficace se non utilizzando un codice VBA per risolverlo in Excel. Ma con Kutools for Excel'S Numeri di parole in valuta, converti rapidamente i numeri in parole inglesi o in parole cinesi.


Clic Kutools >> Contenuti >> Numeri in parole, vedi screenshot:

spell incantesimo 1


Uso:

1. Evidenzia l'intervallo in cui vuoi compitare i numeri in ortografia inglese (parole o testo).

2. Applicare l'utilità facendo clic Kutools > Contenuti > Numeri in parolee quindi specificare le lingue nella finestra di dialogo. C'è un pannello di anteprima incorporato che ti consente di vedere immediatamente i risultati. Vedi screenshot:

spell incantesimo 1

3. Quindi fare clic OK or Applica. Tutti i numeri sono stati convertiti in parole inglesi. Vedi gli screenshot:

spell incantesimo 1


Demo: specifica i numeri in inglese o cinese


Kutools for Excel include più di 300 utili strumenti per Excel, gratuiti da provare senza limitazioni nei giorni 30. Scarica e prova gratuita ora!

Strumenti di produttività consigliati
I seguenti strumenti possono notevolmente risparmiare tempo e denaro, quale è giusto per te?
Office Tab: Utilizzo di pratiche schede nel tuo ufficio, come il modo di Chrome, Firefox e New Internet Explorer.
Kutools for Excel: Più di 300 Funzioni avanzate per Excel 2019, 2016, 2013, 2010, 2007 e Office 365.
Classic Menu for Office: Riporta i menu familiari a Office 2007, 2010, 2013, 2016, 2019 e 365, come se fossero Office 2000 e 2003.

Kutools for Excel

La funzionalità sopra descritta è solo una delle potenti funzioni di 300 di Kutools per Excel.

Progettato per Excel (Office) 2019, 2016, 2013, 2010, 2007 e Office 365. Download gratuito e utilizzo per i giorni 60.

Schermata di Kutools per Excel

per saperne di più btn download btn acquisto

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 · 6 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