{"id":6283,"date":"2024-12-21T14:57:31","date_gmt":"2024-12-21T14:57:31","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-chuyen-so-duong-thanh-so-am-trong-excel\/"},"modified":"2024-12-21T14:57:31","modified_gmt":"2024-12-21T14:57:31","slug":"cach-chuyen-so-duong-thanh-so-am-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-chuyen-so-duong-thanh-so-am-trong-excel\/","title":{"rendered":"C\u00e1ch chuy\u1ec3n s\u1ed1 d\u01b0\u01a1ng th\u00e0nh s\u1ed1 \u00e2m trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/hocexcel.online\/\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n nhanh ch\u00f3ng chuy\u1ec3n t\u1ea5t c\u1ea3 s\u1ed1 d\u01b0\u01a1ng th\u00e0nh s\u1ed1 \u00e2m trong Excel.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6766d75ab3a5a\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-duong-thanh-trong-excel.html#Thay_doi_so_duong_thanh_so_am_bang_Paste_Special\" title=\"Thay \u0111\u1ed5i s\u1ed1 d\u01b0\u01a1ng th\u00e0nh s\u1ed1 \u00e2m b\u1eb1ng Paste Special\">Thay \u0111\u1ed5i s\u1ed1 d\u01b0\u01a1ng th\u00e0nh s\u1ed1 \u00e2m b\u1eb1ng Paste Special<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-chuyen-duong-thanh-trong-excel.html#Thay_doi_so_duong_thanh_so_am_bang_VBA\" title=\"Thay \u0111\u1ed5i s\u1ed1 d\u01b0\u01a1ng th\u00e0nh s\u1ed1 \u00e2m b\u1eb1ng VBA\">Thay \u0111\u1ed5i s\u1ed1 d\u01b0\u01a1ng th\u00e0nh s\u1ed1 \u00e2m b\u1eb1ng VBA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Thay_doi_so_duong_thanh_so_am_bang_Paste_Special\"><\/span><strong>Thay \u0111\u1ed5i s\u1ed1 d\u01b0\u01a1ng th\u00e0nh s\u1ed1 \u00e2m b\u1eb1ng Paste Special<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<ol style=\"text-align: justify\">\n<li>Nh\u1ea5n s\u1ed1 -1 v\u00e0o \u00f4 tr\u1ed1ng v\u00e0 sao ch\u00e9p n\u00f3.<\/li>\n<li>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i, sau \u0111\u00f3 nh\u1ea5p ph\u1ea3i v\u00e0 ch\u1ecdn <strong><em>Paste Special<\/em><\/strong> t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong><em>Paste Special<\/em><\/strong> nh\u01b0 h\u00ecnh sau:<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-change-positive-to-negertive1-1.png\" title=\"doc-change-positive-to-negertive1-1\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>\u0110\u00e1nh d\u1ea5u ch\u1ecdn <strong><em>All <\/em><\/strong>trong ph\u1ea7n <strong><em>Paste<\/em><\/strong>, v\u00e0 <strong><em>Multiply<\/em><\/strong> trong ph\u1ea7n <strong><em>Operation<\/em><\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-change-positive-to-negertive2-2.png\" title=\"doc-change-positive-to-negertive2-2\"><\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Nh\u1ea5n OK. T\u1ea5t c\u1ea3 s\u1ed1 d\u01b0\u01a1ng s\u1ebd chuy\u1ec3n th\u00e0nh s\u1ed1 \u00e2m.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-change-positive-to-negertive3-3.png\" title=\"doc-change-positive-to-negertive3-3\"><\/p>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>Cu\u1ed1i c\u00f9ng, x\u00f3a s\u1ed1 -1 n\u1ebfu b\u1ea1n mu\u1ed1n.<\/li>\n<\/ol>\n<h1 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Thay_doi_so_duong_thanh_so_am_bang_VBA\"><\/span><strong>Thay \u0111\u1ed5i s\u1ed1 d\u01b0\u01a1ng th\u00e0nh s\u1ed1 \u00e2m b\u1eb1ng <a href=\"http:\/\/blog.ezworkapp.com\/bat-dau-voi-excel-macros-va-lap-trinh-vba.html\" target=\"_blank\" rel=\"noopener noreferrer\">VBA<\/a><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">S\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-chen-va-chay-ma-vba-trong-excel-2010-2016-huong-dan-cho-nguoi-moi-bat-dau.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>m\u00e3 VBA<\/strong><\/a>, b\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n s\u1ed1 d\u01b0\u01a1ng th\u00e0nh s\u1ed1 \u00e2m nh\u01b0ng b\u1ea1n c\u1ea7n bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng n\u00f3.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i.<\/li>\n<li>Ch\u1ecdn <strong><em>Developer &gt; Visual Basic<\/em><\/strong>, c\u1eeda s\u1ed5 <strong><em>Microsoft Visual Basic for applications<\/em><\/strong> m\u1edf ra, nh\u1ea5p <strong><em>Insert &gt; Module<\/em><\/strong>, sao ch\u00e9p v\u00e0 d\u00e1n \u0111o\u1ea1n m\u00e3 sau v\u00e0o module:<\/li>\n<\/ol>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/04756b9385045190020327bee2b8a8ef\">Gist<\/a>.<\/div>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Nh\u1ea5p n\u00fat \u0111\u1ec3 ch\u1ea1y \u0111o\u1ea1n m\u00e3, h\u1ed9p tho\u1ea1i thu nh\u1ecf \u0111\u1ec3 b\u1ea1n ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i t\u1eeb s\u1ed1 d\u01b0\u01a1ng th\u00e0nh \u00e2m.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-change-positive-to-negertive4-4.png\" title=\"doc-change-positive-to-negertive4-4\"><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-240.gif\" title=\"vba101_92019-nho-240\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-566.gif\" title=\"ex101_92019-nho-566\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Nh\u1ea5n OK, c\u00e1c gi\u00e1 tr\u1ecb d\u01b0\u01a1ng trong v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn \u0111\u00e3 \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i th\u00e0nh gi\u00e1 tr\u1ecb \u00e2m.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong><em>Ngu\u1ed3<\/em><\/strong><strong><em>n:<\/em><\/strong><em>\u00a0<\/em><em>Ablebits, d\u1ecb<\/em><em>ch v\u00e0 bi\u00ean t\u1ead<\/em><em>p b\u1edf<\/em><em>i Hocexcel Online.<\/em><\/p>\n<p style=\"text-align: left\">N\u1ebfu b\u1ea1n ch\u01b0a l\u00e0m vi\u1ec7c nhi\u1ec1u tr\u00ean Excel th\u00ec c\u00f3 th\u1ec3 vi\u1ec7c th\u1ef1c hi\u1ec7n nh\u1eefng thao t\u00e1c n\u00e0y kh\u00f4ng ph\u1ea3i \u0111i\u1ec1u d\u1ec5 d\u00e0ng. H\u00e3y \u0111\u1ec3 <a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online <\/a>\u0111\u1ed3ng h\u00e0nh v\u00e0 c\u00f9ng b\u1ea1n bi\u1ebfn Excel th\u00e0nh c\u00f4ng c\u1ee5 h\u1eefu d\u1ee5ng, \u0111\u1ec3 l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n, nhanh ch\u00f3ng h\u01a1n.<\/p>\n<p style=\"text-align: left\">Hi\u1ec7n nay\u00a0Ho\u0323c Excel Online \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">H\u1ecdc Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/a>\u00a0v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u1ec7u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u1ea7n tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: left\">\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-240.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6284,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6283","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6283","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=6283"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6283\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6284"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}