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