Microsoft Query, from excel file: number formats

[Sibrulotte]

Hi,
I have an amount in each of our VPs credit card summary excel file, and I was trying to retrieve them without having to open the files individualy. What i know, is using the microsoft query in excel can refresh itself without having to open all the source files.

The only problem is the formating of the numbers that come back. The amount I'm looking for is in a colomn that starts with a number, then text for 3 lines, 2 empty rows and my amount.

So the result from the query cannot be added as it stands. I though it took the format of the first row to apply it to the rest of the data retrieved in that colomn. And also, I could get an amount that could be added when the 3rd text line was a date.

Anyone know what I am talking about?

[Sibrulotte]

So I guess noone knows what I'm talking about.

Get data: from other source: Microsoft Query. Then in Microsoft Query use the excel driver...
Data in my colomn I want to retrieve info is in various formats. The row I'm trying to look into is a number, but the result of the query is not a number. I thought the format of the result was given by the first value of the colomn you are retrieving. Is that plausible?