i have been getting many sheets where the phone number is not formatted in (###) ###-####, if the column the number is in is text i can reformat by adding a column, formatted that column for phone numbers, converting old data to numbers and just do =a1, etc... in the new column.. the problem is they are not usually in text format, usually general formatting. So when i try this i just get the same formatting.. is there a formula or function that would help.
Bookmarks