in reply to Re^4: excel format problem
in thread excel format problem
Yes, but now Excel will ignore it as a number. For example, with cell B4 containing =SUM(B1:B3):
| A | B | |
| 1 | 1 | |
| 2 | 0x2 | |
| 3 | 3 | |
| 4 | Total: | 4 |
— the total is 4, not 6 as expected. As a rule, numerical data entered into an Excel spreadsheet should be available to be used as numerical data — that’s what a spreadsheet is for, after all! So, prefer choroba’s approach given above.
Hope that helps,
| Athanasius <°(((>< contra mundum | Iustus alius egestas vitae, eros Piratica, |
|
|---|