Forum Discussion
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...
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
I prefer numbers, is there a way to format the entire row in to the number and formatting I had?
(954) 563-5567 like this?
If in place that's by macro similar to one which HansVogelaar suggested, but in opposite direction. If to copy into another place that could be done by formulas, not sure what do you prefer.
