Format....cells....custom, choose any type and in the box just below type:
enter 0000

"Linda" wrote:

How can I set up my spreadsheet with one column that will have a four place
number (0000) or if a number is 25 will put two zeros in front of that
number.

Example: 0025
or 0000
or 0045
The column would change the numbers to 0000 if a number is not there or if a
two digit number is there it would change the cell to two zeros in front of
the two digit number 0045.