inserting zero

  • Thread starter Thread starter dfg
  • Start date Start date
D

dfg

hi there

i need to insert a zero in front of a range of numbers

7011117050
7011117051
7011117052
7011117053

also they will not drag to the next number in sequence

thanks
 
Format as 00000000000

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
You must log in or register to reply here.

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

How to count the maximum number flanked by zeros 9
Adding recognised Zeros 5
Inserting Number 5
NumberFormat for small non-zero numbers? 2
How can I keep a zero (0) at the front of a set of numbers. 2
count the number of rows with entries greater than zero 1
Leading zeroes formula 3
Adding a zero to the front of numbers 5

Back
Top