Forum Discussion
Excel numbers stored as text fiasco
My formula didn't work because the numbers are stored as text. I don't care why it's like this. I don't want to know your excuses. I see from the history drop down this has been counter pro...
I don't care why it's like this. I don't want to know your excuses.
Why should we excuse?
It is simply your fault. Either you formatted the cells as text or you imported data and choose not to convert the text numbers to real numbers.
PS: Very 'creative' tag.
- Excuse: You did it wrong!
Very funny.
When the data type is set to number, it should be number.
If MS is going to have numbers that are not numbers, it needs to be 1) very clear and 2) easy to mass repair and 3) get it's head checked.
