Hello!
I have a column with insurance number. They are 8-digits number. Some of them have zeros at the beginning. This info I get from the insurance company. Now we I run a report in our company, our insurance numbers show without zeros. I have to compare both listing to match people. A unique column would the insurance number but it won't because one have zeros the other doesn't. Do you have any suggestions on how I can change cell properties from txt to general to eliminate the zeros without hitting F2 and then enter so change takes effect? Our total records are about 4,500. Any ideas?
Alexandra, TX
I have a column with insurance number. They are 8-digits number. Some of them have zeros at the beginning. This info I get from the insurance company. Now we I run a report in our company, our insurance numbers show without zeros. I have to compare both listing to match people. A unique column would the insurance number but it won't because one have zeros the other doesn't. Do you have any suggestions on how I can change cell properties from txt to general to eliminate the zeros without hitting F2 and then enter so change takes effect? Our total records are about 4,500. Any ideas?
Alexandra, TX