Forum Discussion
Excel wont recognize values when trying to do the average function
Hi! I'm trying to take the average of C337-C354 but excel wont recognize the big numbers (obviously) since the average is 313 as seen in C357. How can I fix this?
7 Replies
Dannni_Yea1240 , Excel definitely recognizes relatively big numbers, if only these are numbers, not texts. When AVERAGE ignores them.
In you sample you have
9 019.57
looks like space is thousand separator and dot separates decimal part.
At the same time you have
22,55
547,34
and here looks like comma separates decimal part.
It shall be no such mix.
You may test in next column do you have numbers or texts by =ISNUMBER()
You are correct!
I have changed to decimal seprator as . and thousands as , but it still wont remove the spaces. Now it looks like this, any idea how to fix this?
Dannni_Yea1240 , perhaps space is part of numbers format which separates thousands, when it's not necessary to remove them. If you test =ISNUMBER(C337) it returns TRUE of FALSE?
