View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default How do you remove phone format????

Select the cells
Right-click and choose Format Cells
In the Number tab, choose TEXT and click OK

"TotallyConfused" wrote:

I have a list of phone number with phone format (###) ###-####. I need to
remove the phone format and replace existing numbers as text "##########"
How do I do this please???? Thank you.