I am trying to export a list of customers. I am using the find feature (F6) and generating a list of all customers. Then I press the Excel button. This is really to be a call list.
The problem is that all fields have the data that I want but start with a "'"
For instance our business phone shows as '2095775067 instead of 2095775067.
This stops me from being able to format the cell. I can not find a way to make it appear as (209)577-5067.
I'm sure this question has been posted before, but I'm not sure how to search for it.