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 |