{"id":1531,"date":"2019-04-07T17:21:14","date_gmt":"2019-04-07T22:21:14","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1531"},"modified":"2019-04-07T17:21:14","modified_gmt":"2019-04-07T22:21:14","slug":"cell-formats-0-0-and-0-00-0","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1531","title":{"rendered":"Cell formats 0.0\\% and 0.0%;(0.0%)"},"content":{"rendered":"<p>We needed a way to force Excel to show the % next to a number without dividing it by 100<\/p>\n<p>You know, when you format a cell in Excel, to show %, it automatically divide that number by 100<\/p>\n<p>But we do not want that to happen this time.<\/p>\n<p>So here is the trick, in custom format, use this 0.0\\% to show the % symbol without dividing it by 100<\/p>\n<p><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2019\/04\/Screenshot_2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-medium wp-image-1534\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2019\/04\/Screenshot_2-300x142.jpg\" alt=\"\" width=\"300\" height=\"142\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Another trick, is to show the brackets around negative percentage, something you do not see by default in list of format.<\/p>\n<p>Here it is<\/p>\n<p>In Custom format, use this 0.0%;(0.0%)<\/p>\n<p>To tell Excel to show percentages in negative between two brackets<\/p>\n<p><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2019\/04\/Screenshot_3.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-medium wp-image-1532\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2019\/04\/Screenshot_3-300x142.jpg\" alt=\"\" width=\"300\" height=\"142\" \/><\/a><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2019\/04\/Screenshot_1-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-medium wp-image-1537\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2019\/04\/Screenshot_1-1-300x142.jpg\" alt=\"\" width=\"300\" height=\"142\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We needed a way to force Excel to show the % next to a number without dividing it by 100 You know, when you format a cell in Excel, to show %, it automatically divide that number by 100 But we do not want that to happen this time. So here is the trick, in&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=1531\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;Cell formats 0.0\\% and 0.0%;(0.0%)&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":1533,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,5,12],"tags":[103,120,136],"class_list":["post-1531","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-format-cells","category-non-functions","category-worksheet","tag-cell","tag-ctrl1","tag-format"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1531","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1531"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1531\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1533"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}