|
Les types de fichiers classiques ne pourront plus être utilisés à partir de janvier 2021. Vous pouvez transférer vos fichiers classiques ou télécharger un PDF. En savoir plus

Number to text

Répondu
Demande de démonstration

In spreadsheets, is there a way to convert a number "1" to its text equivalent "one".  For example, if cell A1 contains "1", is there a formula in A2 I can put to convert that to "one"? Likewise, "2" would read as "two", "3" as "three" etc. Thanks!

0

Commentaires

1 commentaire

Date Votes
  • Lynn Kaminski

    Hi Anthony, this may not answer your specific question, but you can modify the cell properties of A1 to read as text.  Change the Value Format to "Number", and then under Advanced Options, click the "Show numbers as words" box.  Hope that helps!

    0

Vous devez vous connecter pour laisser un commentaire.