Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Location
    Marlborough, Massachusetts, USA
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formating column (O2k W98 Se)

    I have a 1000 line file that I have copied. It is demographic data. 1 column is phone number. I am trying to get it to format to "phone number." It will not. the original was read locked. Is the file too big? left over write protect? 1 data element not lined up correctly? Other? It works on my system with a fresh small sheet.
    Thanks for the help.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formating column (O2k W98 Se)

    Most likely, the column of phone numbers is formatted as text, or the numbers have a single quote in front of each number. Just changing the format from text to a numeric format will not convert text values already entered to numeric. If the telephone numbers do not contain any non-numeric characters, then the following will convert the numbers to numeric:

    1- Select an empty cell on the sheet and enter a 1 into it. Then select Copy form the Edit menu.

    2- Select the column containing the phone numbers.

    3- Select "Paste Special" from the Edit menu.

    4- In the resulting dialog box in the "Operation" section, click on Multiply, then click OK.

    That should convert the text to numbers and the format should now work.
    Legare Coleman

Posting Permissions

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