{"id":5080,"date":"2024-12-09T01:59:19","date_gmt":"2024-12-09T01:59:19","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/dinh-dang-so-am-trong-ke-toan-bang-can-doi-thu-chi\/"},"modified":"2024-12-09T01:59:19","modified_gmt":"2024-12-09T01:59:19","slug":"dinh-dang-so-am-trong-ke-toan-bang-can-doi-thu-chi","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/dinh-dang-so-am-trong-ke-toan-bang-can-doi-thu-chi\/","title":{"rendered":"\u0110\u1ecbnh d\u1ea1ng s\u1ed1 \u00e2m trong k\u1ebf to\u00e1n, b\u1ea3ng c\u00e2n \u0111\u1ed1i thu chi"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"chuy\u1ec3n-d\u1ea5u-\u00e2m-th\u00e0nh-d\u1ea5u-ngo\u1eb7c-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/dinh-dang-so-am-trong-excel.html?chuyen-dau-am-thanh-dau-ngoac-trong-excel\">\n<p>\u0110\u1ecbnh d\u1ea1ng s\u1ed1 \u00e2m nh\u01b0 th\u1ebf n\u00e0y \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt \u2026 nh\u1eefng n\u01a1i b\u1ecb \u00e2m trong b\u1ea3ng t\u00ednh. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 chuy\u1ec3n d\u1ea5u \u00e2m th\u00e0nh d\u1ea5u ngo\u1eb7c trong excel? B\u00e0i vi\u1ebft n\u00e0y s\u1ebd b\u1eadt m\u00ed cho b\u1ea1n. \u0110\u1eebng b\u1ecf qua nh\u00e9!<\/p>\n<\/blockquote>\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-67564ef6c00db\" 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-so-am-trong-excel.html#Dong_ngoac_don_so_am\" title=\"\u0110\u00f3ng ngo\u1eb7c \u0111\u01a1n s\u1ed1 \u00e2m\">\u0110\u00f3ng ngo\u1eb7c \u0111\u01a1n s\u1ed1 \u00e2m<\/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-so-am-trong-excel.html#Dong_ngoac_don_va_to_do_so_am\" title=\"\u0110\u00f3ng ngo\u1eb7c \u0111\u01a1n v\u00e0 t\u00f4 \u0111\u1ecf s\u1ed1 \u00e2m\">\u0110\u00f3ng ngo\u1eb7c \u0111\u01a1n v\u00e0 t\u00f4 \u0111\u1ecf s\u1ed1 \u00e2m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-so-am-trong-excel.html#Dong_ngoac_so_tien_am\" title=\"\u0110\u00f3ng ngo\u1eb7c s\u1ed1 (ti\u1ec1n) \u00e2m\">\u0110\u00f3ng ngo\u1eb7c s\u1ed1 (ti\u1ec1n) \u00e2m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-so-am-trong-excel.html#Dong_ngoac_va_to_do_so_tien_am\" title=\"\u0110\u00f3ng ngo\u1eb7c v\u00e0 t\u00f4 \u0111\u1ecf s\u1ed1 (ti\u1ec1n) \u00e2m\">\u0110\u00f3ng ngo\u1eb7c v\u00e0 t\u00f4 \u0111\u1ecf s\u1ed1 (ti\u1ec1n) \u00e2m<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-so-am-trong-excel.html#Neu_ban_quan_tam_den_cac_van_de_khac_dinh_dang_so_am_trong_Excel_ban_co_the_tham_khao_1_so_bai_viet_sau_day\" title=\"N\u1ebfu b\u1ea1n quan t\u00e2m \u0111\u1ebfn c\u00e1c v\u1ea5n \u0111\u1ec1 kh\u00e1c \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u00e2m trong Excel, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o 1 s\u1ed1 b\u00e0i vi\u1ebft sau \u0111\u00e2y:\">N\u1ebfu b\u1ea1n quan t\u00e2m \u0111\u1ebfn c\u00e1c v\u1ea5n \u0111\u1ec1 kh\u00e1c \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u00e2m trong Excel, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o 1 s\u1ed1 b\u00e0i vi\u1ebft sau \u0111\u00e2y:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Dong_ngoac_don_so_am\"><\/span>\u0110\u00f3ng ngo\u1eb7c \u0111\u01a1n s\u1ed1 \u00e2m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>B\u01b0\u1edbc 1<\/strong><\/p>\n<p>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ecbnh d\u1ea1ng s\u1ed1 r\u1ed3i b\u1ea5m ph\u00edm t\u1eaft <strong>CTRL + 1\u00a0<\/strong>tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>Format Cells\u2026<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2414 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-01-03-at-00-12-51-1024x668-1.png\" alt=\"dinh dang so am trong excel\" width=\"1024\" height=\"668\" title=\"screen-shot-2017-01-03-at-00-12-51-1024x668-1\"><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong><\/p>\n<ol>\n<li>Ch\u1ecdn th\u1ebb Number<\/li>\n<li>Ch\u1ecdn Category <strong>Custom<\/strong><\/li>\n<li>Trong ph\u1ea7n Type:\u00a0<strong>#,##0_);(#,##0)<\/strong><\/li>\n<li>B\u1ea5m OK<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Dong_ngoac_don_va_to_do_so_am\"><\/span>\u0110\u00f3ng ngo\u1eb7c \u0111\u01a1n v\u00e0 t\u00f4 \u0111\u1ecf s\u1ed1 \u00e2m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 \u0111\u00f3ng ngo\u1eb7c \u0111\u01a1n v\u00e0 t\u00f4 \u0111\u1ecf s\u1ed1 \u00e2m ta l\u00e0m theo t\u1eebng b\u01b0\u1edbc nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong><\/p>\n<p>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ecbnh d\u1ea1ng s\u1ed1 r\u1ed3i b\u1ea5m ph\u00edm t\u1eaft <strong>CTRL + 1\u00a0<\/strong>tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>Format Cells\u2026<\/strong><\/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-427.gif\" title=\"ex101_92019-nho-427\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2415 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-01-03-at-00-18-04-1024x677-1.png\" alt=\"dinh dang so am trong excel\" width=\"1024\" height=\"677\" title=\"screen-shot-2017-01-03-at-00-18-04-1024x677-1\"><\/p>\n<blockquote>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Dong_ngoac_so_tien_am\"><\/span>\u0110\u00f3ng ngo\u1eb7c s\u1ed1 (ti\u1ec1n) \u00e2m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 \u0111\u1ecbnh d\u1ea1ng \u0111\u00f3ng ngo\u1eb7c s\u1ed1 ti\u1ec1n \u00e2m, ta s\u1ebd s\u1eed d\u1ee5ng custom format nh\u01b0 sau:<\/p>\n<p><strong>[$VND ]* #,##0_);[$VND ]* (#,##0)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2417 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-01-03-at-00-22-28-1024x267-1.png\" alt=\"dinh dang so am trong excel\" width=\"1024\" height=\"267\" title=\"screen-shot-2017-01-03-at-00-22-28-1024x267-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Dong_ngoac_va_to_do_so_tien_am\"><\/span>\u0110\u00f3ng ngo\u1eb7c v\u00e0 t\u00f4 \u0111\u1ecf s\u1ed1 (ti\u1ec1n) \u00e2m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 \u0111\u1ecbnh d\u1ea1ng \u0111\u00f3ng ngo\u1eb7c v\u00e0 t\u00f4 \u0111\u1ecf s\u1ed1 ti\u1ec1n trong Excel, ta s\u1eed d\u1ee5ng custom number format nh\u01b0 sau:<\/p>\n<p><strong>[$VND ]* #,##0_);[Red][$VND ]* (#,##0)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2418 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-01-03-at-00-23-58-1024x287-1.png\" alt=\"\u0110\u1ecbnh d\u1ea1ng s\u1ed1 \u00e2m trong Excel\" width=\"1024\" height=\"287\" title=\"screen-shot-2017-01-03-at-00-23-58-1024x287-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Neu_ban_quan_tam_den_cac_van_de_khac_dinh_dang_so_am_trong_Excel_ban_co_the_tham_khao_1_so_bai_viet_sau_day\"><\/span><strong>N\u1ebfu b\u1ea1n quan t\u00e2m \u0111\u1ebfn c\u00e1c v\u1ea5n \u0111\u1ec1 kh\u00e1c \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u00e2m trong Excel, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o 1 s\u1ed1 b\u00e0i vi\u1ebft sau \u0111\u00e2y:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li><a href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-su-dung-custom-format.html\" target=\"_blank\" rel=\"noopener\">\u0110\u1ecbnh d\u1ea1ng s\u1ed1 b\u1eb1ng custom format<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/dinh-dang-tien-trong-excel-voi-custom-formats.html\" target=\"_blank\" rel=\"noopener\">\u0110\u1ecbnh d\u1ea1ng s\u1ed1 ti\u1ec1n b\u1eb1ng custom format<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-trong-excel.html\" target=\"_blank\" rel=\"noopener\">\u0110\u1ecbnh d\u1ea1ng n\u00e2ng cao trong Excel<\/a><\/li>\n<\/ol>\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-427.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5081,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5080","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\/5080","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=5080"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5080\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5081"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}