Imported from the Apple Support Forums via the Wayback Machine 🔗
You can format the cell as text and enter the parenthesis & spaces manually.
Regards,
0
marklovesportland·
Imported from the Apple Support Forums via the Wayback Machine 🔗
You're kidding, right?
I am speaking of hundreds of numbers, in a column, that I want to "change" to an easier-to-read phone number format.
0
5|=vv·
Imported from the Apple Support Forums via the Wayback Machine 🔗
If your phone numbers are in column A, for instance, you can create a new column populated (filled down) with a formula like:
="("&LEFT(A1,3)&") "&MID(A1,3,3)&"-"&RIGHT(A1,4)
If you'd then rather not retain the old column A values, then select this new column and "Edit"/"Cut" and then select column A and "Edit"/"Paste Values".
0
marklovesportland·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Hi,
Thanks for the formula. I tried it, but noticed that my phone number "changes" one digit.
="("&LEFT(A1,3)&") "&MID(A1,3,3)&"-"&RIGHT(A1,4)
for example, when I use (503) 555-1212, it changes to
(503) 355-1212.
I'm too new to Numbers to understand the formula, but this is definitely on the right track.
Mark
0
WWJD·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Value to be parsed is in cell A3.
Use:
="("&LEFT(A3,3)&") "&MID(A3,4,3)&"-"&RIGHT(A3,4)
Regards,
Look at Help for the MID function to get better understanding what the function does.
0
5|=vv·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Sorry... there was a silly error in my formula that caused it to double up third digit. WWJD's formula has this corrected. I'm glad you caught it.
0
marklovesportland·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Hi,
Thank you both for your help, as this is PERFECT for me!
Mark
0
WWJD·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Please send Feedback to Apple for expanded formatting for values (Telephone, Zip Code, etc...) You can find this on Numbers' main menu.
Regards,
0
Apple fan Michael·
Imported from the Apple Support Forums via the Wayback Machine 🔗
5|-vv,
Nice tip. I wrote up a step by step, walk through for it on the blog. You can find it here: