You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Format cells as phone numbers in Numbers 10.3.5

How does one format cells as phone numbers in Numbers 10.3.5?


I see answers for Numbers 3.0, but there doesn't seem to be a "Numbers and Text" option to choose in 10.3.5.


Thanks!

Posted on Dec 11, 2020 7:12 AM

Reply
Question marked as Top-ranking reply

Posted on Dec 11, 2020 11:59 PM

Just set up a Custom Format so it looks like this (or whatever telephone number format you use in your region):




You can find the 'Create Custom Format at the bottom of the Data Format dropdown in the Cell tab of the pain at the right.


This works whether you have your "number" as a number or as text in the cell.


Just drag the Integer elements up into the box, type the - in between them and choose 'Hide Separator' in the last integer token (by clicking the v and choosing from the dropdow).


This is for display only. If you want to actually change the values in the cells then you would need to use a formula similar to:


=LEFT(A2,3)&"-"&MID(A2,4,3)&"-"&RIGHT(A2,4)


where the 10-digit number is in A2.


To "remove" the formula(s) you would then command-c to copy, and Edit > Paste Formula Results. This will result in text in the cells(s).


SG

3 replies
Question marked as Top-ranking reply

Dec 11, 2020 11:59 PM in response to AmericanMaleVoiceover

Just set up a Custom Format so it looks like this (or whatever telephone number format you use in your region):




You can find the 'Create Custom Format at the bottom of the Data Format dropdown in the Cell tab of the pain at the right.


This works whether you have your "number" as a number or as text in the cell.


Just drag the Integer elements up into the box, type the - in between them and choose 'Hide Separator' in the last integer token (by clicking the v and choosing from the dropdow).


This is for display only. If you want to actually change the values in the cells then you would need to use a formula similar to:


=LEFT(A2,3)&"-"&MID(A2,4,3)&"-"&RIGHT(A2,4)


where the 10-digit number is in A2.


To "remove" the formula(s) you would then command-c to copy, and Edit > Paste Formula Results. This will result in text in the cells(s).


SG

Format cells as phone numbers in Numbers 10.3.5

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.