Crystal Report Exported to Excel Cell type is text vs number

[mermar]

I have monthly reports that I export from a crystal and when I do this the numbers in the cell are 'Text' I highlight and change to number, however, this still does not convert it. I can not sum columns. I change the file type when converting to Excel Workbook Data-Only (xlsl). I have to click into each cell to complete it to convert to a number.

NUMBER	LINE ITEMS	VALUE	LINE ITEMS	VALUE	LINE ITEMS	VALUE	LINE ITEMS	VALUE	DEL. DAYS
AMAZO	0	0.00	0	0.00	0	0.00	1	42.24	76.00
ARRO	1	48.60	18	1345.06	1	2.95	1	1.65	2.00
ASM	0	0.00	1	745.80	0	0.00	1	116.88	13.00
AVNE	2	214.80	3	235.19	0	0.00	0	0.00	-3.00
BULL	0	0.00	1	42.00	0	0.00	0	0.00	0.00

 

[AhoyNC]

Try this.

1. Put the number 1 in a cell.
2. Copy that cell.
3. Highlight the range of numbers to change to numeric.
4. Paste - Paste Special - Multiply
5. OK

 

[mermar]

Thank You for the advice. The Multiply did not work, but the Add did.

 

[AhoyNC]

If you used add just make sure you add 0 and not 1 to your numbers. The trick here is that if you do an arithmetic function to a text number Excel (in most cases) will change it to a value. So by adding 0 or multiplying by 1 should change the text value to numeric and keep the value the same.