Arte SheetsLearn. Try. Understand.

Text

Convert numbers to text: preserve leading zeros and fixed formats with TEXT

Format numeric IDs, dates, and currency amounts as text strings with TEXT when building codes or labels.

Open spreadsheet ↗

Keep leading zeros when joining numeric IDs into labels

Concatenating a number directly with & strips custom number formatting ("INV-" & 42 becomes "INV-42"). Wrapping the number in TEXT(A2, "0000") pads integers with leading zeros to four digits ("INV-0042").

Use "0.0%" for percentage labels or "yyyy-mm-dd" for ISO dates inside concatenated strings.

="INV-" & TEXT(A2, "0000")

Try the example

Use the original values or change them to test your understanding.