Excel query is returning only part of the data from a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Even while previewing while still in the query, data is previewing as 5
numerals with a decimal point, e.g., 5555.0, when numbers are in format of 4
numerals, or 4 numerals and a letterin the original spreadsheet. Those with
letters are not showing at all.
Have tried formatting the original column as text, or general, but this has
no effect.
??
 
amanda said:
Even while previewing while still in the query, data is previewing as 5
numerals with a decimal point, e.g., 5555.0, when numbers are in format of 4
numerals, or 4 numerals and a letterin the original spreadsheet. Those with
letters are not showing at all.
Have tried formatting the original column as text, or general, but this has
no effect.
Click to expand...

For info on mixed data types, see:

http://www.dicks-blog.com/excel/2004/06/external_data_m.html

Jamie.

--
 
Back
Top