Left-Pad SKU Numbers to 6 Digits

You're an inventory analyst preparing 12 SKU numbers for upload to the new ERP. The legacy export gives them as plain integers of varying width (42, 1234, 12345); the ERP requires every code to be a 6-character zero-padded string ("000042", "001234", "012345").

Your task:

1. In column B (Padded Code), write a formula that returns the 6-digit zero-padded string for each SKU number.
2. The formula must drag-fill from B2 → B13.

The two acceptable patterns:

• TEXT (recommended): =TEXT(A2, "000000") — TEXT formats a number against a format string; the 0 placeholder pads with zeros on the left if the input is shorter, and lets longer inputs through unchanged.
• RIGHT + REPT: =RIGHT(REPT("0", 6) & A2, 6) — concatenate six leading zeros, then take the last 6 characters. Works for inputs up to 6 digits; truncates anything longer (a 7-digit number loses its leading digit), so prefer this only when input width is bounded.

Graded cells: B2 (42 → 000042), B5 (89 → 000089), B11 (45678 → 045678).