How to sum these numbers in excel

hi Shuwyyyy 

probably you copied/loaded data that has different symbols for thousand seperator and comma than you in the regionals settings of your windows.

to fix:

- select column

- replace . by ,

- replace , by .

- replace <space> by nothing

after that all figures should be aligned right, indicating they are now numbers you can calculate with

BR

Jeroen Heerschop

Get Responsive