HOW DO I FORMAT A NUMBER PRECEDED BY TWO O'S?
 

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?

HOW DO I FORMAT A NUMBER PRECEDED BY TWO O'S?
 

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?

HOW DO I FORMAT A NUMBER PRECEDED BY TWO O'S?
 

If all your numbers are of equal length of 8 digits then custom format them
with format code 0000000000 (ten zeros)!

Regards,
Stefi

€žOWL QUEEN€� ezt Ã*rta:

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?