View Single Post
  #1   Report Post  
Bassai Bassai is offline
Junior Member
 
Posts: 1
Default Help Needed - Making Numbers

Hi

I want to make a group of numbers but am having trouble. What I am trying to do is make a list like this:

092660000
092660001
092660002
092660003

I get the bit about A1 + 1 and then copy and paste but every time I do it Excel takes out the first 0 so I end up with a list that looks like this:

92660000
92660001
92660002
92660003

thats not what I want, I must have the 0 in front.

Any ideas?