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