Problem with drag and drop formatting

[aintlifegrand79]

I have a database that uses zip codes to find data about reps and filll a
userform. My problem is that large ranges of zip codes have more than 1 rep
covering that area and therefore I have had to create multiple entries for
many of the zip codes. The problem is when i create a series of zip codes
such as 60000, 60000, 60001, 60001, 60002,60002, 60003, 60003 and then drag
and drop to continue the series in the cells below it doesn't keep the
formatting. In other words instead of the next cells being 60004, 60004,
60005, 60005 they are 60003.856748987, 60004.14693892, 60004.74355324346989,
60005.3125097879234. I don't know if there is some other way of formatting
these cells so they only have 5 digits in them or some other answer but I am
just hoping I don't have to go and change all of these cells by hand cause
their is about 300,000 of them. Thanks.

 

[Dick Kusleika]

I have a database that uses zip codes to find data about reps and filll a
userform. My problem is that large ranges of zip codes have more than 1 rep
covering that area and therefore I have had to create multiple entries for
many of the zip codes. The problem is when i create a series of zip codes
such as 60000, 60000, 60001, 60001, 60002,60002, 60003, 60003 and then drag
and drop to continue the series in the cells below it doesn't keep the
formatting. In other words instead of the next cells being 60004, 60004,
60005, 60005 they are 60003.856748987, 60004.14693892, 60004.74355324346989,
60005.3125097879234. I don't know if there is some other way of formatting
these cells so they only have 5 digits in them or some other answer but I am
just hoping I don't have to go and change all of these cells by hand cause
their is about 300,000 of them. Thanks.

I don't think Fill Series will work for that. You could put a formula below
the second 60003

=IF(A8=A7,A8+1,A8)

And fill that down. Then Copy and Paste Special > Values