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?
|