Question

B. typing before a leading zero treats as number as tex

Answer 1

Format as Text

Select the range of cells you want to enter leading zeros in.

Go to the Home tab.

In the Numbers section click on the Format Dropdown selection.