I am working on a project where the fax numbers always appear in this format "000/000-0000".
In order for the corresponding software to recognize this format, I need this list of faxes to have the format of "000-000-0000. Is there a custom cell format that can be applied or should I look towards a macro that will convert this for me every time a new list is pasted? Or maybe i'm completely overlooking a cell format that will do it for me already!
Thank you for any help.