number format

[Greg]

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

[Jason Morin]

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