Results 1 to 3 of 3

Number format switch

Threaded View

  1. #1
    Registered User
    Join Date
    01-15-2009
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2003
    Posts
    6

    Smile Number format switch

    Hi guys!

    I have several phone numbers that I copy and paste from the web:
    I.E:

    (888) 456-7890
    (333) 234-5678

    I need to switch all of them to just standard numbers: They should look like this:

    8884567890
    3332345678

    I go to "format" - "cells" - "numbers" but nothing works. I wonder if any formula can do it. It should work for ALL THE LIST, I want something else than change them one by one by hand.

    Thank you!!!
    Lorena
    Last edited by oldchippy; 08-16-2009 at 04:47 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1