Results 1 to 4 of 4

Change cell properties

This is a discussion on Change cell properties within the Excel Questions forums, part of the Question Forums category; Hello! I have a column with insurance number. They are 8-digits number. Some of them have zeros at the beginning. ...

  1. #1
    New Member
    Join Date
    Sep 2003
    Posts
    7

    Default Change cell properties

    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

  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330

    Default Re: Change cell properties

    Couple of ideas:

    1 - you could use a formula in an adjacent column to convert the insurance numbers to numeric. Something like =VALUE(A1).

    2 - you could convert the entire column to numbers. Select the column of data and then, from the main menu, select Data|TextToColumns. Follow the prompts at the Text To Columns Wizard.

    Hope this helps,
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  3. #3
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,186

    Default Re: Change cell properties

    How about Custom Formatting the cells to eights digits?

  4. #4
    New Member
    Join Date
    Sep 2003
    Posts
    7

    Default Re: Change cell properties

    Guys!!! You are amazing. I used the VALUE formula. IT WORKED. Thanks Barrie. I would try the other suggestions as well just for extra knowledge.

    I love you guys!!!! Alexandra

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com