number format
 

I am typing in telephone numbers to Excel. An example is 01253712345. Excel
removes the leading zero, however when I type in ' before the number, the 0
is displayed.
I want to run consecutive numbers, so type in +sum(a1+1) to give consecutive
numbers. However, the zero again disappears.

How can I apply a custom format to a cell that already contains a +sum
formula?

Thanks

Replace your formula with:

=TEXT(A1+1,"0000000000")

HTH
Jason
Atlanta, GA

-----Original Message-----
I am typing in telephone numbers to Excel. An example
is 01253712345. Excel
removes the leading zero, however when I type in '
before the number, the 0
is displayed.
I want to run consecutive numbers, so type in +sum(a1+1)
to give consecutive
numbers. However, the zero again disappears.

How can I apply a custom format to a cell that already
contains a +sum
formula?

Thanks
.