Excel numbers stored as text fiasco

Occasional Contributor

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 productive for people for years.

 

It's like really bad shareware!  MS is dumb. 

 

 

The warning "numbers are stored as text" shows with one cell selected but not with multiple cells selectedNow I have to figure out where the stupid option is.  NOT PRODUCTIVE!

 

When I change these cells from text to numbers, they should become numbers!

 

"Text as numbers" is complete insanity!

2 Replies

@ToasterGhost 

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.