Hi
I am having an Excel sheet to which I am deriving values form an application.When I tried to use =sum(F2:F9) it is returning 0,then I tried to convert my column into numbers using text to columns in data tab,it worked only for euro currency ,the remaining currencies are still having the same problem,please help me to solve this.
Solved Excel sum returns 0
Share
Right-click an empty cell and chose Copy
Select the data that is giving you problems
Right-click and choose Paste Special
Click the box next to Add
OK your way back out
Hopefully adding zero to the cells will convert them to numbers.
Let us know…
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.