Export Roster to Excel - Losing Phone Format

[m stroup]

I am exporting a simple query with phone numbers to excel. The export works
fine, but the phone numbers does not keep the formatting I selected, even
though I said to "store with t

 

[pietlinden]

I am exporting a simple query with phone numbers to excel.  The export works
fine, but the phone numbers does not keep the formatting I selected, even
though I said to "store with t

sounds like you just need to create the format....

"(" & left$(PhoneNo,3) & ") " & mid$(PhoneNo,3) & "-" & Right$(PhoneNo,
4)

create a query, add that as an expression, then export the expression
instead of the original unformatted telephone number.