Forum Discussion
Formatting problem with telephone numbers in excel.
I have a large excel file (905 names) where the telephone number is formatted xxx-xxx-xxxx. The phonebank program I'm using will not accept numbers in this format - they need to be xxxxxxxxxx or (...
Hi Damien_Rosario,
What I meant
- if texts simply select all cells, Ctrl+H and replace dashes on nothing
- if numbers with format like 999-999-9999 when change it on General
Thanks for the info, Sergei. This is why you are my favourite Excel MVP!
Thank you!