format errors on excel import

[lgoodwin]

This has been a persistent problem through several betas and the release version. I have attached a template I use for a monthly newsletter. On page 4, you will see a box which imports and excel spreadsheet with our board of directors information. 
The problem is that the phone number field imports inconsistently, with most of the entries being in error (I have replaced the actual numbers with "x" for security reasons). Any ideas on how I might correct this problem?

Thanks,

 

template-Beta-test.afpub

[Old Bruce]

23 minutes ago, lgoodwin said:

The problem is that the phone number field imports inconsistently, with most of the entries being in error (I have replaced the actual numbers with "x" for security reasons). Any ideas on how I might correct this problem?

 

Make certain that the cells containing the phone numbers in the Excel spreadsheet are formatted as text in the Excel spreadsheet.

[lgoodwin]

49 minutes ago, Old Bruce said:

Make certain that the cells containing the phone numbers in the Excel spreadsheet are formatted as text in the Excel spreadsheet.

Oh! I had formatted them with the Excel Phone number format.

[Gabe]

Hi @lgoodwin,

We would need a sample excel file to see what's going on. Maybe just replace the original phone numbers with some random ones? 

[lgoodwin]

Hard to do now, since I have responded to other suggestions. My suspicion is that there was something in the phone number data entry that was a problem. When I converted the column to text format and cleaned it up it imported fine. When I then deleted everything in the column and reentered the data specifying telephone number format it also imported fine. Problem solved, I guess.