ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I format phone numbers with periods (https://www.excelbanter.com/new-users-excel/224769-how-do-i-format-phone-numbers-periods.html)

Blu

How do I format phone numbers with periods
 
I've been typing phone numbers with periods instead of dashes...when I go to
format phone numbers on Excel spreadsheet it comes up - the number.

Any suggestions?

Dave Peterson

How do I format phone numbers with periods
 
Save your workbook (just in case)
select the range of phone numbers
edit|replace
what: . (period)
with: (leave blank)
replace all

Now use format|cells|number tab
to apply your phone number format.

Blu wrote:

I've been typing phone numbers with periods instead of dashes...when I go to
format phone numbers on Excel spreadsheet it comes up - the number.

Any suggestions?


--

Dave Peterson


All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com