When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number.

This will require users to update their contacts to add the area code. Most employees have smartphones which use either ActiveSync or our BES to sync their contact list with Exchange.