We receive requests from time to time for how you can properly format a phone number (after the fact) when a user has registered within DotNetNuke or using Dynamic Registration but the masked editor or formatting regular expression was never implemented at that time. I wanted to post a query we have used from time to time that can properly format the phone number data.