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.

--
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
MS Query in Excel 1
ADO with mixed data 2
VBA- Excel Programming:- 0
Keep cell position in a formula after data is deleted 2
Prints only part of specificed print area 1
For Joey2004 et al. From OP: Re Appending Question 3
Formatting Numeric Fields from Within MS Query 1

Back
Top