Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with drag and drop formatting
On Tue, 22 Jul 2008 14:56:01 -0700, aintlifegrand79
wrote: 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 -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drag & Drop | Excel Worksheet Functions | |||
Drag and Drop | Excel Programming | |||
drag and drop problem | Excel Discussion (Misc queries) | |||
Drag and drop | New Users to Excel | |||
Drag and Drop | Excel Programming |