{"id":2644,"date":"2024-12-02T08:18:07","date_gmt":"2024-12-02T08:18:07","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/dinh-dang-don-vi-tien-te-trong-excel-voi-custom-formats\/"},"modified":"2024-12-02T08:18:07","modified_gmt":"2024-12-02T08:18:07","slug":"dinh-dang-don-vi-tien-te-trong-excel-voi-custom-formats","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/dinh-dang-don-vi-tien-te-trong-excel-voi-custom-formats\/","title":{"rendered":"\u0110\u1ecbnh d\u1ea1ng \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 trong Excel v\u1edbi Custom Formats"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u00e0i vi\u1ebft n\u00e0y s\u1ebd chia s\u1ebb v\u1edbi c\u00e1c b\u1ea1n m\u1ed9t th\u1ee7 thu\u1eadt \u0111\u01a1n gi\u1ea3n s\u1eed d\u1ee5ng Custom Format \u1edf trong Excel \u0111\u1ec3 gi\u00fap tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u, \u0111\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng con s\u1ed1 hi\u1ec7u qu\u1ea3 h\u01a1n, d\u1ec5 nh\u00ecn h\u01a1n v\u00e0 d\u1ec5 \u0111\u1ecdc h\u01a1n \u2013 trong \u0111\u00f3 c\u00f3 \u0111\u1ecbnh d\u1ea1ng \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 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-674d6d3e89c22\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-tien-trong-excel-voi-custom-formats.html#Vi_sao_dinh_dang_so_tien_trong_bang_tinh\" title=\"V\u00ec sao \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ti\u1ec1n trong b\u1ea3ng t\u00ednh?\">V\u00ec sao \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ti\u1ec1n trong b\u1ea3ng t\u00ednh?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-tien-trong-excel-voi-custom-formats.html#Lam_the_nao_de_dinh_dang_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng trong Excel?\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng trong Excel?<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Vi_sao_dinh_dang_so_tien_trong_bang_tinh\"><\/span>V\u00ec sao \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ti\u1ec1n trong b\u1ea3ng t\u00ednh?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel l\u00e0 m\u1ed9t ch\u1ee7 \u0111\u1ec1 th\u00fa v\u1ecb v\u00e0 gi\u00fap \u00edch cho c\u00e1c b\u1ea1n r\u1ea5t nhi\u1ec1u trong vi\u1ec7c tr\u00ecnh b\u00e0y t\u00e0i li\u1ec7u Excel v\u00e0 b\u00e1o c\u00e1o, \u0111\u1eb7c bi\u1ec7t v\u1edbi nh\u1eefng b\u00e1o c\u00e1o li\u00ean quan \u0111\u1ebfn t\u00e0i ch\u00ednh v\u00e0 nh\u1eefng con s\u1ed1 nhi\u1ec1u nhi\u1ec1u s\u1ed1 0. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd chia s\u1ebb v\u1edbi c\u00e1c b\u1ea1n m\u1ed9t th\u1ee7 thu\u1eadt \u0111\u01a1n gi\u1ea3n s\u1eed d\u1ee5ng Custom Format \u1edf trong Excel \u0111\u1ec3 gi\u00fap tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u, \u0111\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng con s\u1ed1 hi\u1ec7u qu\u1ea3 h\u01a1n, d\u1ec5 nh\u00ecn h\u01a1n v\u00e0 d\u1ec5 \u0111\u1ecdc h\u01a1n. <a href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-su-dung-custom-format.html\">M\u1ed9t b\u00e0i vi\u1ebft t\u1ed5ng qu\u00e1t h\u01a1n<\/a> v\u1ec1 custom formats, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm \u0111\u1ecdc b\u1eb1ng c\u00e1ch b\u1ea5m <a href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-su-dung-custom-format.html\">v\u00e0o \u0111\u00e2y<\/a>.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_dinh_dang_trong_Excel\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng trong Excel?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u00fang ta s\u1ebd \u0111i \u0111\u1ecbnh d\u1ea1ng c\u00e1c con s\u1ed1 n\u00e0y theo c\u00e1c \u0111\u01a1n v\u1ecb ngh\u00ecn, tri\u1ec7u v\u00e0 t\u1ec9 nh\u01b0 trong h\u00ecnh m\u00ecnh ho\u1ea1. C\u00e1c b\u1ea1n l\u01b0u \u00fd, trong d\u00f2ng Custom Format ch\u00fang ta th\u1ea5y t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u1ed7i c\u1ed9t l\u00e0 2 \u0111\u1ecbnh d\u1ea1ng, \u0111\u1ecbnh d\u1ea1ng ph\u00eda tr\u00ean l\u00e0 chu\u1ea9n ch\u00e2u \u00c2u, \u0111\u1ecbnh d\u1ea1ng ph\u00eda d\u01b0\u1edbi l\u00e0 chu\u1ea9n M\u1ef9. C\u00e1c b\u1ea1n l\u00e0m theo h\u01b0\u1edbng d\u1eabn v\u00e0 th\u1eed chu\u1ea9n ph\u00f9 h\u1ee3p v\u1edbi m\u00e1y t\u00ednh c\u1ee7a m\u00ecnh.<\/p>\n<p><strong>B\u01b0\u1edbc 1: Ch\u1ecdn d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ecbnh d\u1ea1ng.\u00a0B\u1ea5m chu\u1ed9t ph\u1ea3i r\u1ed3i ch\u1ecdn Format Cells<\/strong><\/p>\n<figure id=\"attachment_601\" aria-describedby=\"caption-attachment-601\" style=\"width: 622px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/001-bam-format-cells.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-601 size-full\" title=\"1 - \u0110\u1ecbnh d\u1ea1ng \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 v\u1edbi custom formats\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/001-bam-format-cells.png\" alt=\"1 - \u0110\u1ecbnh d\u1ea1ng \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 v\u1edbi custom formats\" width=\"622\" height=\"529\"><\/a><figcaption id=\"caption-attachment-601\" class=\"wp-caption-text\">1 \u2013 \u0110\u1ecbnh d\u1ea1ng \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 v\u1edbi custom formats<\/figcaption><\/figure>\n<p><strong>B\u01b0\u1edbc 2:<\/strong><strong>\u00a0S\u1eed d\u1ee5ng c\u00e1c Custom Formats nh\u01b0 h\u00ecnh v\u1ebd<\/strong><\/p>\n<figure id=\"attachment_602\" aria-describedby=\"caption-attachment-602\" style=\"width: 528px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/002-bam-format-cells.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-602 size-full\" title=\"2 - \u0110\u1ecbnh d\u1ea1ng \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 v\u1edbi custom formats\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/002-bam-format-cells.png\" alt=\"2 - \u0110\u1ecbnh d\u1ea1ng \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 v\u1edbi custom formats\" width=\"528\" height=\"470\"><\/a><figcaption id=\"caption-attachment-602\" class=\"wp-caption-text\">2 \u2013 \u0110\u1ecbnh d\u1ea1ng \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 v\u1edbi custom formats<\/figcaption><\/figure>\n<p>V\u00ed d\u1ee5 minh ho\u1ea1<\/p>\n<figure id=\"attachment_603\" aria-describedby=\"caption-attachment-603\" style=\"width: 811px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/003-feature.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-603 size-full\" title=\"3 - \u0110\u1ecbnh d\u1ea1ng \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 v\u1edbi custom formats\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/003-feature.png\" alt=\"3 - \u0110\u1ecbnh d\u1ea1ng \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 v\u1edbi custom formats\" width=\"811\" height=\"496\"><\/a><figcaption id=\"caption-attachment-603\" class=\"wp-caption-text\">3 \u2013 \u0110\u1ecbnh d\u1ea1ng \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 v\u1edbi custom formats<\/figcaption><\/figure>\n<p><strong>B\u1ea1n c\u00f3 th\u1ec3 download v\u00ed d\u1ee5 minh ho\u1ea1 n\u00e0y t\u1ea1i \u0111\u00e2y<\/strong><\/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-86.gif\" title=\"vba101_92019-nho-86\"><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-204.gif\" title=\"ex101_92019-nho-204\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>[sociallocker id=457]<\/p>\n<p><a href=\"http:\/\/bit.ly\/heoEX101\">Download<\/a><\/p>\n<p>[\/sociallocker]<\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <strong><a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a><\/strong><\/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\/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-86.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2645,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2644","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\/2644","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=2644"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2644\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2645"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}