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

  • Thread starter Thread starter OWL QUEEN
  • Start date Start date
O

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?
 
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
 
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:
 
Back
Top