Q: How can I add leading zeros to a number?
A: Select the cells and choose Custom Format from the Format menu. Type zero ("0") as many times as you want digits in your number. A custom format of "0000" will yield a result of "0010" when "10" is entered in the cell.