Byg Software
007
How do I have leading zeros before a number? How do I make 123 look like 000123
Select the cell or range:
Format > Cells >Number
Select "Custom" category
Type 000000 into the "Type:" box.
Close