Label an amount with its currency

Turn 1234.5 into USD 1,234.50 with the label and decimals you choose.

What you'll make

In Excel: 1234.5, USD, 2 decimals becomes USD 1,234.50.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1B8The currency label, like USD."USD"
2&" "&Adds one space after the label."USD "
3IF(C8=0, … )Adds a decimal point and one 0 per decimal.".00"
4TEXT(A8,"#,##0"& … )Writes the amount with commas and those decimals."USD 1,234.50"

Excel works from the inside out: part 3 builds the pattern, then part 4 uses it. With 0 decimals there is no decimal point. The amounts are made-up.

=B8&" "&TEXT(A8,"#,##0"&IF(C8=0,"","."&REPT("0",C8)))

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own amounts. Paste amounts, currency labels and decimals into the green columns of the Template tab.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

This only adds a label. It doesn't convert currencies, so check each label matches its amount.

Microsoft's help: TEXT function