How to convert numbers to words

by

In this tutorial I’ll show you how to convert numbers to words in Excel using a LAMBDA function, NumberToText.

Steps to convert numbers to words

  1. Open Excel and enter a number in cell A1.
  2. Type the formula: =NumberToText(A1)
  3. Press Enter.
  4. The formula will return the number in words, e.g., “One Thousand Two Hundred Thirty-Four” for 1234.

Example

Basic example

Explanation

…

Workaround without LAMBDA

…

Download section