Text › TEXT56 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

MediumFreeTEXT

TEXT: invoice numbers with leading zeros

Mrs. Ratih runs a catering business in Yogyakarta. Her invoice numbers look like INV-0007: the letters INV, a hyphen, then a 4-digit sequence number padded with leading zeros.

Task

Fill C2:C6 with the invoice number built from the sequence number in column A, for example 7 becomes INV-0007. Use TEXT.

Cells to fillC2:C6

Required functionsTEXT

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
TEXT(number, "format") converts a number into text with a given format.
Hint 2
In a format code, 0 means a required digit. The format "0000" always produces 4 digits, adding leading zeros when needed.
Hint 3
Join the text "INV-" with the result of TEXT using & (or CONCAT).

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

C2:C6

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

Write it in C2, then fill down to C6.

Explanation

=TEXT(A2,"0000") turns 7 into the text "0007", and & attaches it after "INV-". Setting the cell format to 0000 only changes the display; the value is still 7, so the zeros vanish as soon as it is joined with other text. Number 1024 already has 4 digits, so no zeros are added. Tip: the same format works for customer codes, queue numbers, or employee ID numbers.

Starting worksheet: Sheet1
Row	A	B	C
1	Seq. no.	Customer	Invoice no.
2	7	Keluarga Hartono
3	23	Arisan Ibu RT 05
4	158	Kantor Notaris Wijaya
5	1024	Pengajian Al-Ikhlas
6	5	Panitia Reuni SMA 1999
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result