{"id":202316,"date":"2023-10-09T16:02:12","date_gmt":"2023-10-09T16:02:12","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/"},"modified":"2023-10-09T16:02:12","modified_gmt":"2023-10-09T16:02:12","slug":"how-to-make-negative-value-positive-in-excel","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/","title":{"rendered":"How to make negative value positive in Excel?"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#How_to_make_negative_value_positive_in_Excel\" title=\"How to make negative value positive in Excel?\">How to make negative value positive in Excel?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#FAQs\" title=\"FAQs:\">FAQs:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#1_Can_I_use_a_formula_to_make_negative_values_positive_in_Excel\" title=\"1. Can I use a formula to make negative values positive in Excel?\">1. Can I use a formula to make negative values positive in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#2_How_do_I_use_the_ABS_function_to_make_negative_values_positive\" title=\"2. How do I use the ABS function to make negative values positive?\">2. How do I use the ABS function to make negative values positive?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#3_Can_I_apply_the_custom_number_format_to_specific_cells_only\" title=\"3. Can I apply the custom number format to specific cells only?\">3. Can I apply the custom number format to specific cells only?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#4_Can_I_convert_negative_values_to_positive_values_without_formatting_cells\" title=\"4. Can I convert negative values to positive values without formatting cells?\">4. Can I convert negative values to positive values without formatting cells?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#5_What_if_I_want_to_keep_the_original_negative_values_in_Excel\" title=\"5. What if I want to keep the original negative values in Excel?\">5. What if I want to keep the original negative values in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#6_Is_there_a_keyboard_shortcut_to_quickly_convert_negative_values_to_positive_in_Excel\" title=\"6. Is there a keyboard shortcut to quickly convert negative values to positive in Excel?\">6. Is there a keyboard shortcut to quickly convert negative values to positive in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#7_Can_I_make_negative_values_positive_in_Excel_for_an_entire_column_at_once\" title=\"7. Can I make negative values positive in Excel for an entire column at once?\">7. Can I make negative values positive in Excel for an entire column at once?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#8_Will_converting_negative_values_to_positive_affect_my_calculations_in_Excel\" title=\"8. Will converting negative values to positive affect my calculations in Excel?\">8. Will converting negative values to positive affect my calculations in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#9_Can_I_make_negative_values_positive_based_on_a_certain_condition_in_Excel\" title=\"9. Can I make negative values positive based on a certain condition in Excel?\">9. Can I make negative values positive based on a certain condition in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#10_How_can_I_quickly_switch_between_displaying_negative_and_positive_values_in_Excel\" title=\"10. How can I quickly switch between displaying negative and positive values in Excel?\">10. How can I quickly switch between displaying negative and positive values in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#11_Will_making_negative_values_positive_affect_the_sorting_of_my_data_in_Excel\" title=\"11. Will making negative values positive affect the sorting of my data in Excel?\">11. Will making negative values positive affect the sorting of my data in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#12_Can_I_undo_the_conversion_of_negative_values_to_positive_in_Excel\" title=\"12. Can I undo the conversion of negative values to positive in Excel?\">12. Can I undo the conversion of negative values to positive in Excel?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"How_to_make_negative_value_positive_in_Excel\"><\/span>How to make negative value positive in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When working with data in Excel, you may come across negative values that you want to convert to positive values. Here&#8217;s how you can do it:<\/p>\n<p>1. Select the cell or range of cells that contain the negative values you want to make positive.<br \/>\n2. Right-click on the selected cells and choose &#8220;Format Cells&#8221; from the context menu.<br \/>\n3. In the Format Cells dialog box, go to the &#8220;Number&#8221; tab.<br \/>\n4. Select &#8220;Custom&#8221; from the Category list.<br \/>\n5. In the Type box, enter the following custom number format: 0;0;0;@<\/p>\n<p>This custom number format tells Excel to display all numbers as positive, effectively converting negative values to positive. Click &#8220;OK&#8221; to apply the format to the selected cells, and you will see the negative values now appear as positive values.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"FAQs\"><\/span>FAQs:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"1_Can_I_use_a_formula_to_make_negative_values_positive_in_Excel\"><\/span>1. Can I use a formula to make negative values positive in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use a formula to make negative values positive in Excel. One common formula to achieve this is to use the ABS function, which returns the absolute value of a number.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_How_do_I_use_the_ABS_function_to_make_negative_values_positive\"><\/span>2. How do I use the ABS function to make negative values positive?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can use the ABS function in Excel by typing =ABS(value) in a cell, where &#8220;value&#8221; is the cell reference or number you want to make positive.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Can_I_apply_the_custom_number_format_to_specific_cells_only\"><\/span>3. Can I apply the custom number format to specific cells only?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can apply the custom number format to specific cells by selecting those cells before following the steps to format them.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Can_I_convert_negative_values_to_positive_values_without_formatting_cells\"><\/span>4. Can I convert negative values to positive values without formatting cells?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can convert negative values to positive values without formatting cells by using a formula like =-A1, where A1 is the cell containing the negative value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_What_if_I_want_to_keep_the_original_negative_values_in_Excel\"><\/span>5. What if I want to keep the original negative values in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf you want to keep the original negative values in Excel while also displaying them as positive, you can use a helper column to store the positive values while retaining the negative values in the original column.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_Is_there_a_keyboard_shortcut_to_quickly_convert_negative_values_to_positive_in_Excel\"><\/span>6. Is there a keyboard shortcut to quickly convert negative values to positive in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nWhile there isn&#8217;t a specific keyboard shortcut to convert negative values to positive in Excel, you can create a custom keyboard shortcut for the custom number format you&#8217;ve set up to make the process quicker.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Can_I_make_negative_values_positive_in_Excel_for_an_entire_column_at_once\"><\/span>7. Can I make negative values positive in Excel for an entire column at once?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can make negative values positive in Excel for an entire column at once by selecting the entire column and applying the custom number format to it.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_Will_converting_negative_values_to_positive_affect_my_calculations_in_Excel\"><\/span>8. Will converting negative values to positive affect my calculations in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nConverting negative values to positive in Excel will only affect how the values are displayed, not how they are used in calculations. The underlying data remains unchanged.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Can_I_make_negative_values_positive_based_on_a_certain_condition_in_Excel\"><\/span>9. Can I make negative values positive based on a certain condition in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can make negative values positive based on a certain condition in Excel by using conditional formatting or creating a formula that checks for the condition before converting the values.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_How_can_I_quickly_switch_between_displaying_negative_and_positive_values_in_Excel\"><\/span>10. How can I quickly switch between displaying negative and positive values in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can quickly switch between displaying negative and positive values in Excel by using the custom number format you&#8217;ve set up. Simply apply the format to the cells again to toggle between the two.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_Will_making_negative_values_positive_affect_the_sorting_of_my_data_in_Excel\"><\/span>11. Will making negative values positive affect the sorting of my data in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nMaking negative values positive in Excel will not affect the sorting of your data, as Excel sorts based on the actual values stored in the cells, not how they are displayed.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_Can_I_undo_the_conversion_of_negative_values_to_positive_in_Excel\"><\/span>12. Can I undo the conversion of negative values to positive in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf you want to undo the conversion of negative values to positive in Excel, you can simply clear the custom number format applied to the cells, and they will revert to displaying negative values.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to make negative value positive in Excel? When working with data in Excel, you may come across negative values that you want to convert to positive values. Here&#8217;s how you can do it: 1. Select the cell or range of cells that contain the negative values you want to make positive. 2. Right-click on &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to make negative value positive in Excel?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#more-202316\">Read more<span class=\"screen-reader-text\">How to make negative value positive in Excel?<\/span><\/a><\/p>\n","protected":false},"author":51,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-202316","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to make negative value positive in Excel?<\/title>\n<meta name=\"description\" content=\"How to make negative value positive in Excel? When working with data in Excel, you may come across negative values that you want to convert to positive\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to make negative value positive in Excel?\" \/>\n<meta property=\"og:description\" content=\"How to make negative value positive in Excel? When working with data in Excel, you may come across negative values that you want to convert to positive\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synchronyfinancial\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-09T16:02:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"164\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Adam Forbes\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@synchrony\" \/>\n<meta name=\"twitter:site\" content=\"@synchrony\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Adam Forbes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/\"},\"author\":{\"name\":\"Adam Forbes\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060\"},\"headline\":\"How to make negative value positive in Excel?\",\"datePublished\":\"2023-10-09T16:02:12+00:00\",\"dateModified\":\"2023-10-09T16:02:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/\"},\"wordCount\":655,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"articleSection\":[\"Learn\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/\",\"name\":\"How to make negative value positive in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2023-10-09T16:02:12+00:00\",\"dateModified\":\"2023-10-09T16:02:12+00:00\",\"description\":\"How to make negative value positive in Excel? When working with data in Excel, you may come across negative values that you want to convert to positive\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to make negative value positive in Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"description\":\"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co\",\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/namso-gen.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"contentUrl\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"width\":500,\"height\":164,\"caption\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\"},\"image\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synchronyfinancial\",\"https:\/\/twitter.com\/synchrony\",\"https:\/\/www.youtube.com\/synchronyfinancial\",\"https:\/\/www.instagram.com\/synchrony\",\"https:\/\/www.linkedin.com\/company\/synchrony-financial\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060\",\"name\":\"Adam Forbes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"Adam Forbes\"},\"description\":\"Guest author Adam Forbes has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to make negative value positive in Excel?","description":"How to make negative value positive in Excel? When working with data in Excel, you may come across negative values that you want to convert to positive","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to make negative value positive in Excel?","og_description":"How to make negative value positive in Excel? When working with data in Excel, you may come across negative values that you want to convert to positive","og_url":"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2023-10-09T16:02:12+00:00","og_image":[{"width":500,"height":164,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","type":"image\/png"}],"author":"Adam Forbes","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Adam Forbes","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/"},"author":{"name":"Adam Forbes","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060"},"headline":"How to make negative value positive in Excel?","datePublished":"2023-10-09T16:02:12+00:00","dateModified":"2023-10-09T16:02:12+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/"},"wordCount":655,"commentCount":0,"publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"articleSection":["Learn"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/","url":"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/","name":"How to make negative value positive in Excel?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2023-10-09T16:02:12+00:00","dateModified":"2023-10-09T16:02:12+00:00","description":"How to make negative value positive in Excel? When working with data in Excel, you may come across negative values that you want to convert to positive","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-make-negative-value-positive-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to make negative value positive in Excel?"}]},{"@type":"WebSite","@id":"https:\/\/namso-gen.co\/blog\/#website","url":"https:\/\/namso-gen.co\/blog\/","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","description":"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co","publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/namso-gen.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/namso-gen.co\/blog\/#organization","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","url":"https:\/\/namso-gen.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","contentUrl":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","width":500,"height":164,"caption":"Namso Gen Blog - Free Credit Card Generator [100% Valid]"},"image":{"@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synchronyfinancial","https:\/\/twitter.com\/synchrony","https:\/\/www.youtube.com\/synchronyfinancial","https:\/\/www.instagram.com\/synchrony","https:\/\/www.linkedin.com\/company\/synchrony-financial"]},{"@type":"Person","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060","name":"Adam Forbes","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Adam Forbes"},"description":"Guest author Adam Forbes has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here."}]}},"_links":{"self":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/202316","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/users\/51"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=202316"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/202316\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media\/107420"}],"wp:attachment":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media?parent=202316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=202316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=202316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}