{"id":158,"date":"2009-09-13T14:08:00","date_gmt":"2009-09-13T18:08:00","guid":{"rendered":"http:\/\/exceltheatre.com\/blog\/archives\/2009\/09\/13\/excel-numbers-do-not-sum-correctly\/"},"modified":"2021-05-17T11:27:04","modified_gmt":"2021-05-17T15:27:04","slug":"excel-numbers-do-not-sum-correctly","status":"publish","type":"post","link":"https:\/\/exceltheatre.com\/blog\/archives\/2009\/09\/13\/excel-numbers-do-not-sum-correctly\/","title":{"rendered":"Excel Numbers Do Not Sum Correctly"},"content":{"rendered":"<p>If you copy data from another program to Excel, Excel might treat the numbers as text, and totals that use these numbers will be incorrect. <\/p>\n<p>This video shows the simple steps to change the text &quot;numbers&quot; to real numbers. For written instructions, visit <a title=\"Convert Text to Numbers\" href=\"http:\/\/www.contextures.com\/xlDataEntry03.html\">Convert Text to Numbers<\/a> <\/p>\n<div class=\"wlWriterSmartContent\" id=\"scid:5737277B-5D6D-4f48-ABFC-DD9C333F4C5D:2de8e760-155e-4c1f-afd2-17f86630ef0d\" style=\"padding-right: 0px; display: inline; padding-left: 0px; float: none; padding-bottom: 0px; margin: 0px; padding-top: 0px\">\n<div id=\"a35f0646-f2cb-4fde-bda7-9cddeac7de39\" style=\"padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px\">\n<div><embed src=\"https:\/\/www.youtube.com\/v\/cAoCB1HwPXU&amp;hl=en\" width=\"425\" height=\"355\" type=\"application\/x-shockwave-flash\" \/><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p>\n<p>______________________<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you copy data from another program to Excel, Excel might treat the numbers as text, and totals that use these numbers will be incorrect. This video shows the simple steps to change the text &quot;numbers&quot; to real numbers. For written instructions, visit Convert Text to Numbers ______________________<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_kadence_starter_templates_imported_post":false,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-158","post","type-post","status-publish","format-standard","hentry","category-excel-videos"],"_links":{"self":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/158","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/comments?post=158"}],"version-history":[{"count":1,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/158\/revisions"}],"predecessor-version":[{"id":4226,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/158\/revisions\/4226"}],"wp:attachment":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media?parent=158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/categories?post=158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/tags?post=158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}