Forum Discussion
Excel sum/counting issue
Hi there. am literally pulling my hair out and wonder if anyone else has come across this issue and can advise. Use excel all the time.. got a new laptop from work last week .. was OK and still ...
This is because computer thinks it as test not number.
First solution is :
- Select the cells containing the data you want to summarize.
- Go to the "Home" tab and check the Number Format dropdown, or just right click and select format cells
- Ensure the format is set to "Number" or "Currency" (if applicable) and not "Text." Text formatting prevents numerical calculations.
But if it is not working then
Second solution is :
- Select cells ----Go to DATA---- Text to Columns------select fix width- next -next go to ADVANCE
- In Advance field replace Decimal separator by comma separator which make it number.---- OK and Finish