I have a spreadsheet with a list of phone numbers displayed with a text format:
I need to have it displayed as (555) 760-1234.
I tried to format > special > phone number and also format > custom > (###) ###-####
but nothing happens when I try to change the format. Any ideas?
I know I can add columns with ( ) and - and then combine the cells but I am looking for a faster method since I have to repeat this process often. I am not sure why the format option doesn't work in this case. It works when I format the date, time, etc.
Thanks for any help.