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

[OWL QUEEN]

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?

 

[Mike H]

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

 

[Stefi]

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: