{"id":936,"date":"2021-10-20T01:18:52","date_gmt":"2021-10-20T01:18:52","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=936"},"modified":"2021-10-20T01:19:35","modified_gmt":"2021-10-20T01:19:35","slug":"solved-excel-sum-returns-0","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/excel-sum-returns-0\/20813.html","title":{"rendered":"Solved Excel sum returns 0"},"content":{"rendered":"<p>Hi<br \/>\nI 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.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":3},"question-category":[53],"question_tags":[],"class_list":["post-936","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=936"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=936"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=936"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}