Excel Tip: Have you ever received a data file that had telephone numbers without formatting, like in the left screenshot below, starting in row 2? Without formatting, you don’t really know if it’s a regular number or a phone number. You can use the Special category on the Number formatting tab to correctly format the phone numbers. Select the Phone Number type in the Type box as indicated in the right screenshot.
For support on using the Special number format, contact me at email@example.com. Need help with Excel - coaching, data analysis and/or training? Contact me at 561-289-9484 to discuss your needs.