title: external data formatting strips off leading zero
body: <p>I am using excel 2003 and importing an external data source from an asp page.</p>
  
  <p>This page returns a table of data that populates the excel cells.</p>
  
  <p>If a cell has a phone number in it, the leading zero is removed by excel, although if I look at the query in the import dialog, the zero is still there!</p>
  
  <p>The cells have been formatted as "text" in the hope this would not happen, but still the text gets treated as a number!</p>
  
  <p>Any ideas? I could really do with some help on this one.</p>