Excel Crystal Report Numeric Column Conversion
Posted on 2014-03-24
I am using an Excel fie as datasource for Crystal Reports. In the Excel file is a column that contains Account Numbers that is mainly numbers but also have some cells with alpha values. I formatted the cells / column as text value. In Crystal Reports, I would use the Excel file ( DAO ) as datasource. The Account Number column is somehow defined as Numbers
( when I add the field and browse data, the field is type : Number and I only see numeric values ). How do I get Crystal Reports to see this column as text and not number ?
Only numbers are appearing on the report and the text values are being bypassed.