Forum Discussion
chipwdomi
Sep 20, 2021Copper Contributor
excel formatting of telephone numbers
this is in the excel cell how it looks (954) 731-5100 see how the number here is actually all the way to the right in the cell (no cell alignment was used) see there is no ( ) in the f...
SergeiBaklan
Sep 20, 2021Diamond Contributor
First one is number formatted with brackets and dashes. Second one is text. If you prefer texts you may use
=TEXT(A1,"[<=9999999]###-####;(###) ###-####")
to convert