Hi,

In your example you mumbers all have 8 digits so formattting the cells with
a custom format of

0000000000

That's 10 zeroes would work.

Mike

"OWL QUEEN" wrote:

I'm using Microsoft Excel 2003.

I have one of many numbers, i.e. 18980193, 18988426, etc. listed in a
column. How do I format those numbers so they are all preceded by two 0's,
i.e. 0018980193?