in 8.5 - Excel table does not return the numberic fields

[modglin]

Exported a txt file from a Dos program. Then brought it into Excel and saved it with three columns. One has all text information, the second and third have text or numeric fields in them. After saving the file in excel with the spreadsheet defined, I pull the three columns into 8.5. I do have information in all three columns for the all text fields, however, in the second in third column - if the information in that column is the hours worked, it shows as blank! Example:
"store #250" "budget hours" "actual hours"
"total hours" " " " "
"store #300" "budget hours" "actual hours"
"total hours" " " " "
One the Excel spreadsheet the " " are actually populated with information like 40.00 or 25.00
I have tried saving the columns as TEXT same results, tried saving as numberic same results. If I insert a column and enter in new numberic numbers, they are brought into the 8.5 report. Any help or suggestions would be GREATLY appreciated.

 

[synapsevampire]

Insert a fasle row in the beginning of the spreadsheet which clearly identifies it's type, then you can filter it out in Crystal.

Excel is a horrible data source, and this is a common problem.

-k