{"id":5212,"date":"2024-12-10T00:44:53","date_gmt":"2024-12-10T00:44:53","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/huong-dan-cach-doi-don-vi-trong-excel\/"},"modified":"2024-12-10T00:44:53","modified_gmt":"2024-12-10T00:44:53","slug":"huong-dan-cach-doi-don-vi-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/huong-dan-cach-doi-don-vi-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ed5i \u0111\u01a1n v\u1ecb trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u00e3y gi\u1ea3 s\u1eed r\u1eb1ng \u0111\u00f4i khi b\u1ea1n c\u1ea7n ph\u1ea3i \u0111\u1ed5i \u0111\u01a1n v\u1ecb trong b\u1ea3ng t\u00ednh (t\u1eeb centimet sang inch, t\u1eeb m\u00e9t sang centimet\u2026). Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3.<\/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-67578f0480f97\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/doi-don-vi-trong-excel.html#Doi_don_vi_trong_Excel_su_dung_phep_nhan\" title=\"\u0110\u1ed5i \u0111\u01a1n v\u1ecb trong Excel s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n\">\u0110\u1ed5i \u0111\u01a1n v\u1ecb trong Excel s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/doi-don-vi-trong-excel.html#Doi_don_vi_trong_Excel_su_dung_ham_Convert\" title=\"\u0110\u1ed5i \u0111\u01a1n v\u1ecb trong Excel s\u1eed d\u1ee5ng h\u00e0m Convert\">\u0110\u1ed5i \u0111\u01a1n v\u1ecb trong Excel s\u1eed d\u1ee5ng h\u00e0m Convert<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Doi_don_vi_trong_Excel_su_dung_phep_nhan\"><\/span>\u0110\u1ed5i \u0111\u01a1n v\u1ecb trong Excel s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nh\u01b0 c\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft, 1 m\u00e9t b\u1eb1ng 100 centimet, 1 inch b\u1eb1ng 2.54 cm\u2026 \u0110\u1ec3 \u0111\u1ed5i m\u1ed9t c\u00e1ch t\u01b0\u01a1ng \u0111\u1ed1i, ta ch\u1ec9 c\u1ea7n l\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/nhan-mot-cot-voi-mot-so-co-dinh-trong-excel.html\">thao t\u00e1c nh\u00e2n<\/a>. C\u1ee5 th\u1ec3\u00a0nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24743\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doi-don-vi-1.png\" width=\"591\" height=\"287\" title=\"doi-don-vi-1\"><\/p>\n<p>T\u1ea1i \u00f4 B2 nh\u1eadp c\u00f4ng th\u1ee9c\u00a0<strong>=A2*100<\/strong> (t\u1eeb m sang cm)<strong>,<\/strong> t\u1ea1i \u00f4 C2 nh\u1eadp c\u00f4ng th\u1ee9c\u00a0<strong>=B2*1\/2.54<\/strong> (t\u1eeb cm sang inch). Sau \u0111\u00f3 <strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016.html\">s\u1eed d\u1ee5ng fill<\/a><\/strong> \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i.<\/p>\n<p>Tuy nhi\u00ean, \u0111\u00e2y ch\u1ec9 l\u00e0 c\u00e1ch chuy\u1ec3n \u0111\u1ed5i t\u01b0\u01a1ng \u0111\u1ed1i. Ch\u00fang ta s\u1ebd t\u1edbi v\u1edbi c\u00e1ch ti\u1ebfp theo<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Doi_don_vi_trong_Excel_su_dung_ham_Convert\"><\/span>\u0110\u1ed5i \u0111\u01a1n v\u1ecb trong Excel s\u1eed d\u1ee5ng h\u00e0m Convert<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m\u00a0<strong>Convert<\/strong> cho ph\u00e9p ta chuy\u1ec3n \u0111\u1ed5i \u0111\u01a1n v\u1ecb c\u1ee7a m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng trong b\u1ea3ng t\u00ednh Excel. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=CONVERT(number, from unit, to unit)<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\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-444.gif\" title=\"ex101_92019-nho-444\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>Number\u00a0<\/strong>l\u00e0 s\u1ed1, ho\u1eb7c tham chi\u1ebfu t\u1edbi d\u1eef li\u1ec7u c\u1ea7n chuy\u1ec3n \u0111\u1ed5i<\/p>\n<p><strong>From unit<\/strong> l\u00e0 \u0111\u01a1n v\u1ecb \u0111\u1ea7u, \u0111\u01b0\u1ee3c Excel t\u1ef1 \u0111\u1ed9ng g\u1ee3i \u00fd b\u1eb1ng c\u00e1c ch\u1eef c\u00e1i vi\u1ebft t\u1eaft<\/p>\n<p><strong>To unit<\/strong> l\u00e0 \u0111\u01a1n v\u1ecb cu\u1ed1i, \u0111\u01b0\u1ee3c Excel t\u1ef1 \u0111\u1ed9ng g\u1ee3i \u00fd b\u1eb1ng c\u00e1c ch\u1eef c\u00e1i vi\u1ebft t\u1eaft<\/p>\n<p>Ch\u00fang ta s\u1ebd \u00e1p d\u1ee5ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24744\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doi-don-vi-2.png\" width=\"774\" height=\"287\" title=\"doi-don-vi-2\"><\/p>\n<p>\u0110\u1ec3 \u0111\u1ed5i \u0111\u01a1n v\u1ecb c\u1ee7a \u00f4 A2 t\u1eeb m\u00e9t ra centimet, t\u1ea1i \u00f4 B2 ta nh\u1eadp\u00a0<strong>=CONVERT(A2,\u201dm\u201d,\u201dcm\u201d).<\/strong><\/p>\n<p>\u0110\u1ec3 \u0111\u1ed5i \u0111\u01a1n v\u1ecb c\u1ee7a \u00f4 A2 t\u1eeb m\u00e9t ra inch, t\u1ea1i \u00f4 C2 ta nh\u1eadp =<strong>CONVERT(A2,\u201dm\u201d,\u201din\u201d).<\/strong><\/p>\n<p>Sau \u0111\u00f3 ti\u1ebfp t\u1ee5c s\u1eed d\u1ee5ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/15-%E2%97%8F-cach-su-dung-fill-options-de-nhap-du-lieu.html\">thao t\u00e1c fill<\/a>\u00a0<\/strong>\u0111\u1ec3 ho\u00e0n thi\u1ec7n d\u1eef li\u1ec7u<\/p>\n<hr>\n<p>Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam nh\u1eefng b\u00e0i vi\u1ebft li\u00ean quan sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/chuyen-tu-ngay-thang-date-ve-dinh-dang-number-hoac-chu-text.html\"><strong>Chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng gi\u1eefa Number\/Date-Time\/Text trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/chuyen-doi-ty-gia-tien-te-trong-excel.html\"><strong>H\u01b0\u1edbng d\u1eabn chuy\u1ec3n \u0111\u1ed5i t\u1ef7 gi\u00e1 ti\u1ec1n t\u1ec7 trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-doc-so-tien-thanh-chu-bang-tieng-anh-trong-excel.html\"><strong>H\u01b0\u1edbng d\u1eabn \u0111\u1ecdc s\u1ed1 ti\u1ec1n t\u1eeb s\u1ed1 th\u00e0nh ch\u1eef ti\u1ebfng Anh<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/addin-doc-thanh-chu-tu-hoc-excel-online.html\"><strong>C\u00e1ch\u00a0\u0111\u1ecdc s\u1ed1 ti\u1ec1n t\u1eeb s\u1ed1 th\u00e0nh ch\u1eef ti\u1ebfng Vi\u1ec7t<\/strong><\/a><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/p>\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\/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-444.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5213,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5212","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5212","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=5212"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5212\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5213"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}