Solved Excel sum returns 0

March 31, 2017 at 02:24:09
Specs: Windows 7
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.

See More: Excel sum returns 0

Report •

#1
March 31, 2017 at 03:49:43
✔ Best Answer
Try this...

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.


Report •
Related Solutions


Ask Question