Format Cell
 

Right click on the cell, format cells, under the number tab, select custom,
then in the box, enter 0000000.

Copy the format down as necessary.


"Fausto" wrote in message
...
Hi guys.
How can I have a cell to show 3 zeros before a number automaticaly.
In other words If I enter 5080 in any cell in Column A. It will display
0005080

Thank you