Phone field is text. Looks fine on the web page. Only when bringing it into
Excel does it switch.

"Wondering" wrote:

Try formatting your phone field column as text before you import.

"Kathy" wrote in message
...
I am trying to import an aspx page that uses a gridview control to display
data. User needs it in Excel. I do a web query and it works out, but Excel
cuts off the leading zeroes in the phone field, which is a text field in
the
underlying table. I played with all the options, preserve formatting (or
not), no formatting, etc. Excel keeps changes to general and therefore
deletes the leading zeroes.