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!
Apple Intelligence is now available on iPhone, iPad, and Mac!
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!
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
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
Just to be clear, the solution I posted above requires choosing type Number (not type Text) when setting up a Custom Format, and it will work if you have the cells containing the telephone "numbers" formatted as Number or as Text.
SG
Just to clear up the statement that "there is no numbers and text option" for custom formats in Numbers 10.3.5, there is a number option and there is a text option.
Format cells as phone numbers in Numbers 10.3.5