Dave Stone
asked on
Crystal Reports 9 - Alpha Numeric and Numeric Data in Same Field not Outputting
Hello,
I am attempting to pull data from an Excel file. There is a column that has values that start with both alpha and numeric. The report only pulls the data that starts with alpha. I have tried formatting the cells in that column every which way but I can't get the report to return the values that are numeric. I have attached a file as an example of the Excel file I am working with. Any help with this would be appreciated.
Example_1.xls
I am attempting to pull data from an Excel file. There is a column that has values that start with both alpha and numeric. The report only pulls the data that starts with alpha. I have tried formatting the cells in that column every which way but I can't get the report to return the values that are numeric. I have attached a file as an example of the Excel file I am working with. Any help with this would be appreciated.
Example_1.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect! Thank you.
What you could try is adding a new column with a simple formula like this:
=""&C2
That will convert numeric values to text and, hopefully, they should be imported into Crystal.