Forum Discussion
philip369
Dec 05, 2019Copper Contributor
Impossible to sum numbers in Excel
I hope someone can help with this because I am pulling my hair out. When I try to sum numbers in a column, at the bottom of the page it gives me a count and not a sum. When I try to Autosum, it g...
philip369
Dec 05, 2019Copper Contributor
Riny_van_Eekelen Yes... like I said I have selected the cells and marked them as numbers... but that doesn't change anything. Grrr.
Riny_van_Eekelen
Dec 05, 2019Platinum Contributor
Understand! But if you format a text as a NUMBER it will still be a text and the SUM function will not work. Say you have " 10" in A1. This a is a text. Try entering the formula =VALUE(A1) to make the text that looks like a number into a real number. Otherwise, upload you workbook so that I can have a look at it.
- FireFox1107715Jan 09, 2022Copper ContributorYessss, thank you bro, it worked fantastically !!!
- philip369Dec 05, 2019Copper Contributor
- Riny_van_EekelenDec 05, 2019Platinum Contributor
Went into your sheet and when I select each cell in column C and press enter in the formula bar, the left justified text becomes a number. Also added a formula in column D to demonstrate what I wrote in my previous message.
- philip369Dec 05, 2019Copper Contributor
Thank you! Is there any way to make this a default?
I've had many versions of Excel and this is the first time I have to go through all these steps for it to recognize text as a number (!)... Isn't that the point of Excel? 🙂
- Subodh_Tiwari_sktneerDec 05, 2019Silver Contributor
I performed the steps I mentioned in my previous post in your sample file.
Please watch the attached video.
- Floris_GS1_NLDec 22, 2021Copper ContributorI have tried this many times, but in my case nothing happens with the format. it stays as it is. The data comes from a table copied from Microsoft OneNote and the column hold only number values.(no decimals, comma's, spaces or other characters). It just won't do a thing!