Max supported value: 999 Trillion.

Worksheet Formula (No VBA)

This single, large formula converts numbers to words without VBA. It handles numbers up to trillions.

Usage: Paste into any cell. It is currently referencing A1.

LAMBDA Function

For Microsoft 365 users, LAMBDA allows you to create a reusable function without VBA. Follow these steps:

  1. Copy the formula below.
  2. Go to Formulas > Name Manager > New.
  4. For ‘Refers to’, paste the copied formula. Click OK.

Customizable VBA Code

Use the options on the left to customize this VBA code. Paste it into a new module in your VBA editor (Alt+F11).

Batch Conversion

Paste a list of numbers (one per line) into the left box. The converted words will appear on the right.

Leave A Comment