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...
Forum Discussion
I performed the steps I mentioned in my previous post in your sample file.
Please watch the attached video.
Subodh_Tiwari_sktneer Thank you!
- I 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!
Although the 'convert to table' still does not work for me, I found a way without having to F2 every cell as @Ringy_van_Eekelen mentioned.
As I said there were no spaces in the cells as I had already done CTRL+SPACE + CTRL+H type 'space' in search field and hit replace all on the specific column, but no spaces were found.
It turned out that what looked like a space in the cell behind the number, was probably something else. So I selected that white space from one cell behind the number, CTRL+C and CTRL+V in the CTRL+H search field and then hit replace all. Then it found 1001 replacements.
Then I had to copy the whole column to Notepad, create a new column in Excel, set the format to Currency and paste the data from Notepad back in the new column. Now Excel see the data as numbers(currency) and can make calculation on it.
