Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2004
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cell Formatting (2000)

    I have a worksheet that has social security numbers listed in a column written originally w/out any dashes (ie - 000000000) but I need to change the format to 000-00-0000. For whatever reason when I highlight and go to format - cell - number - special - social security - nothing happens. However, if I double click in each individual cell the format changes to what I want (000-00-0000). This list has has thousands of employee's numbers on it and it would be a long and tedious process to change them manually.. Is there some sort of protection on the cell that's causing this? Any ideas/suggestions would be great.

    Thanks,
    KC

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Cell Formatting (2000)

    I would guess that they are text and not numbers. The formatting does not work with text.Editing the contents will convert to numbers.

    A quick way to convert all is to:
    go to a blank cell and copy it to the clipboard (ctrl-c)
    then select the range of SS#
    Edit - paste special add
    <ok>

    and they should be converted to numbers

    Steve

  3. #3
    New Lounger
    Join Date
    Aug 2004
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell Formatting (2000)

    Thanks for the imput - I'll let you know how it works out.

    -KC

Posting Permissions

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