1
00:00:00,080 --> 00:00:03,571
A six-digit order code can begin with zero.

2
00:00:03,571 --> 00:00:07,837
If Google Sheets interprets it as a number, the visible 001245

3
00:00:07,837 --> 00:00:11,328
may become 1245, changing the identifier used for matching.

4
00:00:11,328 --> 00:00:15,594
We will preserve three fictional IDs as text before entry and

5
00:00:15,594 --> 00:00:18,309
check that each still has six characters.

6
00:00:18,309 --> 00:00:23,739
We are not adding zeros to a price or doing arithmetic on an ID.

7
00:00:24,339 --> 00:00:29,666
Open the local practice text file and read all three fictional

8
00:00:29,666 --> 00:00:32,087
IDs: 001245, 000327, and 010004.

9
00:00:32,087 --> 00:00:34,024
Keep this source unchanged.

10
00:00:34,024 --> 00:00:38,867
It is the independent reference if an import strips zeros.

11
00:00:38,867 --> 00:00:44,194
Record that the specification is six digits for this exercise; in

12
00:00:44,194 --> 00:00:50,489
a real dataset, confirm the field definition before deciding whether padding is legitimate.

13
00:00:51,089 --> 00:00:55,119
In a disposable Google Sheet, label A1 Order ID and select

14
00:00:55,119 --> 00:00:57,318
the destination cells in column A.

15
00:00:57,318 --> 00:01:01,348
Set their number format to Plain text before pasting the IDs.

16
00:01:01,348 --> 00:01:05,744
Google's number-format guidance explains how to change a selected range.

17
00:01:05,744 --> 00:01:09,774
If you use the file import flow instead, inspect its conversion

18
00:01:09,774 --> 00:01:14,171
choices and do not accept a result until the source digits match.

19
00:01:14,771 --> 00:01:19,544
Paste one ID per row, then click each cell and read the formula bar.

20
00:01:19,544 --> 00:01:23,295
The first ID must still include two leading zeros; the second

21
00:01:23,295 --> 00:01:26,023
must include three; the third begins with one.

22
00:01:26,023 --> 00:01:29,774
Visual padding from a custom number format could look correct while

23
00:01:29,774 --> 00:01:33,525
the stored numeric value is different, so check the actual cell

24
00:01:33,525 --> 00:01:35,571
content as well as its display.

25
00:01:36,171 --> 00:01:40,213
In a spare column, use LEN on A2, A3, and A4.

26
00:01:40,213 --> 00:01:44,990
Each result should be six because the stored identifiers are six characters long.

27
00:01:44,990 --> 00:01:50,135
A result of four or three signals that the original leading zeros were lost.

28
00:01:50,135 --> 00:01:54,177
If that happens, do not fix a real production file from

29
00:01:54,177 --> 00:01:58,955
memory; reset the disposable copy and paste again from the untouched text source.

30
00:01:59,555 --> 00:02:03,552
When the original text is still available, the safest correction is

31
00:02:03,552 --> 00:02:05,732
to re-import it as text.

32
00:02:05,732 --> 00:02:10,093
A six-digit TEXT formula can make a known numeric code display

33
00:02:10,093 --> 00:02:14,090
with zeros, but that is a reconstruction based on a specification,

34
00:02:14,090 --> 00:02:16,270
not recovery of unknown source digits.

35
00:02:16,270 --> 00:02:21,357
Finish by matching each cell to the original file, not by judging appearance alone.