So my landline phone has a built-in blocklist capable of 250 entries. Because of the finite number of entries, I maintain a simple Excel spreadsheet to track:
- The number, entered as 1234567890, is automatically converted to (123) 456-7890.
- The city and state of the area code and prefix, which I manually look up and enter.
Obviously, a database is better suited for this than a spreadsheet, since there are no numbers to be crunched.
But is there an easy way to format a raw number into standard North American telephone format?