I have various phone number formats , such as 

1. +1 (234)-(345)-(3456)
2. 2343453456
3.+45 (234)-(345)-(3456)
4. Some are not even 10 digit numbers . (234-3456)

on Account object . 

Do you have any idea how to format , all these different formats, into one single format . 

(234)-(345)-(3456)

I am thinking of executing a piece of code, through Console . Any sample codes will be appreciated . 

Thanks !! 
Digu