Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Right-Click on the column and chose "Format Cells"

Leave it on"Number" in category and go to where it asks how many "Leading zeroes:" Put in how many digits your number is. In the example below for a 10 digit number I put 10 for Leading zeroes.

Press ok, and now the cells will fill all the empty place values with 0s.

image description