When entering phone numbers to be used with Skype I get formatting issues

Trying to add a "1" to an already existing number If the phone number was originally entered with dashes "-" the number appears as per a normal American telephone formatting = 1(123)456-7891

However when entering a brand new number and not entering dashes - the number does not format at all and is is one big number = 1234567891

If the number appears already as (123)456-7891 and I try to add a "1" it removes all formatting and generates = 12345691

I now have a database full of different formatting sequences = 1(234)456-7891, 1234567891,1234-567-7891, 1234.567.8910

Please advise on how I should enter numbers for Skype and how to clean the database.