Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How do I format a column for phone numbers?
I would like to format all input numbers to have the same format (xxx) xxx-xxxx
Comments
-
There is not a built in phone number format - these numbers will need to be formatted manually.
You could use a concatenate formula in a new column to do this automatically for you.
Try this formula:
="(" + LEFT(Text13, 3) + ") " + MID(Text13, 4, 3) + "-" + RIGHT(Text13, 4)
Text13 is the cell containing the phone number in this example and will turn this:
2068675309
To this:
(206) 867-5309
-
I use to be anal about that until I started calling German friends. Their system does not have a fixed length. Bernt's number is 201 345678 and Simone's number is 177 232 23286. (Don't call them)
My brain still hurts when I think about it.
Craig
-
Don't put the formula into cell Text13.
You need two columns, one with the raw data, one with the formatted data.
Craig
-
I keep getting a #CIRCULAR REFERENCE error trying to get that concatenate formula to work. So, the only way to do it is with two columns - one unformatted and one with forumula.? Please tell me there is a better way.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives