Export Roster to Excel - Losing Phone Format

  • Thread starter Thread starter m stroup
  • Start date Start date
M

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
 
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
Click to expand...

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.
 
Back
Top