Hope someone can help me, I'm using Crystal Reports v10 with a simple report that gets data from a MS Excel 2007 spreadsheet. All the cells in the spreadsheet are TEXT format, but when I create a new report in CR10, and link the spreadsheet, CR10, insista on setting any field which contains numbers to a numeric field type.

 

Would anyone know how to change or stop CR10 from changing field types?

 

"Format Field" does not allow me to change the type from Numeric to Text?

 

Cheers