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 Dale,
Just to clarify, you have Excel numbers like 1234567890 which are formatted as 123-456-7890; or you have text values like '123-456-7890 which you'd like to transform to another text?