number format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel and consecutive number 2
How to count the maximum number of consecutives? 9
Finding location (or start cell) of highest consecutive values 3
Can someone help me please? Prefix to add international diallingcodes to Uk mobile numbers 1
How to count the maximum number flanked by zeros 9
Highest total of any three consecutive numbers in a range. 11
SUMIF with criteria "<>" & "=" 4
Sum number range ignoring numbers formatted as text 0

Back
Top