{"id":1911,"date":"2024-12-02T06:33:57","date_gmt":"2024-12-02T06:33:57","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/dinh-dang-du-lieu-su-dung-custom-format\/"},"modified":"2024-12-02T06:33:57","modified_gmt":"2024-12-02T06:33:57","slug":"dinh-dang-du-lieu-su-dung-custom-format","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/dinh-dang-du-lieu-su-dung-custom-format\/","title":{"rendered":"\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u s\u1eed d\u1ee5ng Custom Format"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><span style=\"font-weight: 400\">N\u1ebfu c\u00e1c b\u1ea1n \u0111\u00e3 \u0111\u1ecdc b\u00e0i v\u1ec1 <a href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-trong-excel.html\">\u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u to\u00e0n t\u1eadp<\/a> ngay ng\u00e0y h\u00f4m tr\u01b0\u1edbc. Nh\u01b0 \u0111\u00e3 n\u00f3i, trong b\u00e0i n\u00e0y ch\u00fang ta s\u1ebd c\u00f9ng nhau t\u00ecm hi\u1ec3u v\u1ec1 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u trong Excel do ch\u00ednh ng\u01b0\u1eddi d\u00f9ng \u0111\u1eb7t ra. T\u1ea5t nhi\u00ean v\u00ec ch\u00fang ta c\u00f3 to\u00e0n quy\u1ec1n quy\u1ebft \u0111\u1ecbnh d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta tr\u00f4ng s\u1ebd nh\u01b0 th\u1ebf n\u00e0o, v\u1eady n\u00ean ch\u00fang ta c\u0169ng c\u1ea7n bi\u1ebft m\u1ed9t v\u00e0i k\u0129 thu\u1eadt \u0111\u1ec3 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh. H\u00e3y pha cho m\u00ecnh m\u1ed9t c\u1ed1c tr\u00e0\/c\u00e0 ph\u00ea v\u00e0 b\u1eaft \u0111\u1ea7u th\u00f4i.<\/span><\/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-674d54d4ce20b\" 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-du-lieu-su-dung-custom-format.html#Mo_cua_so_custom_number_format\" title=\"M\u1edf c\u1eeda s\u1ed5 custom number format:\">M\u1edf c\u1eeda s\u1ed5 custom number format:<\/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-du-lieu-su-dung-custom-format.html#Excel_dinh_dang_so_nhu_the_nao\" title=\"Excel \u0111\u1ecbnh d\u1ea1ng s\u1ed1 nh\u01b0 th\u1ebf n\u00e0o?\">Excel \u0111\u1ecbnh d\u1ea1ng s\u1ed1 nh\u01b0 th\u1ebf n\u00e0o?<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-su-dung-custom-format.html#Nhung_luu_y\" title=\"Nh\u1eefng l\u01b0u \u00fd:\">Nh\u1eefng l\u01b0u \u00fd:<\/a><\/li>\n<\/ul>\n<\/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-du-lieu-su-dung-custom-format.html#Y_nghia_cua_cac_ki_tu_trong_ma_dinh_dang\" title=\"\u00dd ngh\u0129a c\u1ee7a c\u00e1c k\u00ed t\u1ef1 trong m\u00e3 \u0111\u1ecbnh d\u1ea1ng:\">\u00dd ngh\u0129a c\u1ee7a c\u00e1c k\u00ed t\u1ef1 trong m\u00e3 \u0111\u1ecbnh d\u1ea1ng:<\/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-du-lieu-su-dung-custom-format.html#_Mot_so_vi_du\" title=\"\u00a0M\u1ed9t s\u1ed1 v\u00ed d\u1ee5:\">\u00a0M\u1ed9t s\u1ed1 v\u00ed d\u1ee5:<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-su-dung-custom-format.html#Custom_format_co_ban\" title=\"Custom format c\u01a1 b\u1ea3n\">Custom format c\u01a1 b\u1ea3n<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-su-dung-custom-format.html#Custom_format_thay_the_000_bang_K\" title=\"Custom format thay th\u1ebf 000 b\u1eb1ng K\">Custom format thay th\u1ebf 000 b\u1eb1ng K<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-su-dung-custom-format.html#Cac_vi_du_ve_Custom_format_voi_chu_mau_va_dieu_kien\" title=\"C\u00e1c v\u00ed d\u1ee5 v\u1ec1 Custom format v\u1edbi ch\u1eef, m\u00e0u v\u00e0 \u0111i\u1ec1u ki\u1ec7n\">C\u00e1c v\u00ed d\u1ee5 v\u1ec1 Custom format v\u1edbi ch\u1eef, m\u00e0u v\u00e0 \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-su-dung-custom-format.html#Su_dung_custom_format_voi_ki_tu_dac_biet_%E2%80%93_%E2%80%9D%C2%B0C%E2%80%9D\" title=\"S\u1eed d\u1ee5ng custom format v\u1edbi k\u00ed t\u1ef1 \u0111\u1eb7c bi\u1ec7t \u2013 \u00a0#\u201d\u00b0C\u201d\">S\u1eed d\u1ee5ng custom format v\u1edbi k\u00ed t\u1ef1 \u0111\u1eb7c bi\u1ec7t \u2013 \u00a0#\u201d\u00b0C\u201d<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-su-dung-custom-format.html#Su_dung_custom_format_de_dua_ra_thong_diep\" title=\"S\u1eed d\u1ee5ng custom format \u0111\u1ec3 \u0111\u01b0a ra th\u00f4ng \u0111i\u1ec7p\">S\u1eed d\u1ee5ng custom format \u0111\u1ec3 \u0111\u01b0a ra th\u00f4ng \u0111i\u1ec7p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/dinh-dang-du-lieu-su-dung-custom-format.html#Dung_custom_format_de_chen_so_0_dang_truoc_cac_so_khac\" title=\"D\u00f9ng custom format \u0111\u1ec3 ch\u00e8n s\u1ed1 0 \u0111\u1eb1ng tr\u01b0\u1edbc c\u00e1c s\u1ed1 kh\u00e1c\">D\u00f9ng custom format \u0111\u1ec3 ch\u00e8n s\u1ed1 0 \u0111\u1eb1ng tr\u01b0\u1edbc c\u00e1c s\u1ed1 kh\u00e1c<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Mo_cua_so_custom_number_format\"><\/span><span style=\"font-weight: 400\">M\u1edf c\u1eeda s\u1ed5 custom number format:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>\u0110\u1ec3 m\u1edf \u0111\u01b0\u1ee3c c\u1eeda s\u1ed5 n\u00e0y:<\/strong><\/p>\n<ul>\n<li>Ch\u00fang ta ch\u1ecdn \u00f4 c\u1ea7n \u0111\u1ecbnh d\u1ea1ng sau \u0111\u00f3 b\u1ea5m ph\u00edm t\u1eaft CTRL + 1 (B\u1ea5m gi\u1eef CTRL r\u1ed3i nh\u1ea5n ph\u00edm s\u1ed1 1 tr\u00ean b\u00e0n ph\u00edm).<\/li>\n<li>Trong th\u1ebb Number, m\u1ee5c Category, b\u1ea5m v\u00e0o Custom l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y Custom Number Format nh\u01b0 h\u00ecnh minh ho\u1ea1 g\u1ed3m m\u1ee5c Sample gi\u00fap ch\u00fang ta nh\u00ecn th\u1ea5y \u0111\u1ecbnh d\u1ea1ng \u0111\u00f3 s\u1ebd tr\u00f4ng th\u1ebf n\u00e0o, m\u1ee5c Type \u0111\u01b0\u1ee3c Excel \u0111\u1ecbnh ngh\u0129a s\u1eb5n 1 s\u1ed1 ki\u1ec3u ch\u00fang ta s\u1ebd d\u00f9ng.<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">C\u00e1c b\u1ea1n n\u00ean th\u1eed qua c\u00e1c \u0111\u1ecbnh d\u1ea1ng m\u00e0 Excel \u0111\u00e3 cho s\u1eb5n \u1edf \u0111\u00e2y tr\u01b0\u1edbc khi t\u1ea1o ra 1 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ri\u00eang b\u1ea1n, nh\u01b0 v\u1eady ch\u00fang ta s\u1ebd l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n tr\u00ean nh\u1eefng g\u00ec c\u00f3 s\u1eb5n. NH\u01afNG, b\u1ea1n c\u1ea7n ph\u1ea3i bi\u1ebft l\u00e0 n\u00ean d\u00f9ng \u0111\u1ecbnh d\u1ea1ng n\u00e0o? V\u00e0 b\u00e0i n\u00e0y ch\u00fang ta s\u1ebd \u0111i t\u00ecm hi\u1ec3u v\u1ec1 \u0111i\u1ec1u \u0111\u00f3.<\/span><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/create-custom-number-format.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-573\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/create-custom-number-format.png\" alt=\"create-custom-number-format\" width=\"541\" height=\"471\" title=\"create-custom-number-format\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Excel_dinh_dang_so_nhu_the_nao\"><\/span><span style=\"font-weight: 400\">Excel \u0111\u1ecbnh d\u1ea1ng s\u1ed1 nh\u01b0 th\u1ebf n\u00e0o?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-du-lieu-trong-excel.html\">Excel \u0111\u1ecbnh d\u1ea1ng<\/a><\/strong> s\u1ed1 b\u1eb1ng m\u1ed9t ng\u00f4n ng\u1eef nh\u1ecf nh\u01b0 sau, ng\u00f4n ng\u1eef n\u00e0y g\u1ed3m 4 ph\u1ea7n theo th\u1ee9 t\u1ef1, m\u1ed7i ph\u1ea7n l\u00e0 1 \u0111\u1ecbnh d\u1ea1ng \u00e1p d\u1ee5ng cho l\u1ea7n l\u01b0\u1ee3t c\u00e1c tr\u01b0\u1eddng h\u1ee3p s\u1ed1 d\u01b0\u01a1ng, s\u1ed1 \u00e2m, s\u1ed1 0 v\u00e0 text nh\u01b0 sau \u0111\u00e2y:<\/span><\/p>\n<p><strong>&lt;S\u1ed1 d\u01b0\u01a1ng&gt;;&lt;S\u1ed1 \u00e2m&gt;;&lt;S\u1ed1 0&gt;;&lt;Text&gt;<\/strong><\/p>\n<p><span style=\"font-weight: 400\">\u0110i\u1ec1u n\u00e0y ngh\u0129a l\u00e0, khi n\u1ed9i dung trong v\u00f9ng b\u1ea3ng t\u00ednh c\u1ee7a c\u00e1c b\u1ea1n l\u00e0 s\u1ed1 d\u01b0\u01a1ng, Excel s\u1ebd \u0111\u1ecbnh d\u1ea1ng theo nh\u1eefng g\u00ec quy \u0111\u1ecbnh trong m\u1ee5c s\u1ed1 d\u01b0\u01a1ng r\u1ed3i t\u01b0\u01a1ng t\u1ef1 cho c\u00e1c ph\u1ea7n c\u00f2n l\u1ea1i.<\/span><\/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-141.gif\" title=\"ex101_92019-nho-141\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-weight: 400\">X\u00e9t v\u00ed d\u1ee5 sau \u0111\u00e2y<\/span><\/p>\n<figure id=\"attachment_572\" aria-describedby=\"caption-attachment-572\" style=\"width: 935px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dinh-dang-so-trong-excel-01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-572\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dinh-dang-so-trong-excel-01.png\" alt=\"dinh dang so trong excel - 01\" width=\"935\" height=\"283\" title=\"dinh-dang-so-trong-excel-01\"><\/a><figcaption id=\"caption-attachment-572\" class=\"wp-caption-text\">Minh ho\u1ea1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel<\/figcaption><\/figure>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y<\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">S\u1ed1 d\u01b0\u01a1ng \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng v\u1edbi 2 ch\u1eef s\u1ed1 sau d\u1ea5u ph\u1ea9y v\u00e0 s\u1eed d\u1ee5ng d\u1ea5u ph\u1ea9y \u0111\u1ec3 ng\u0103n c\u00e1ch h\u00e0ng ng\u00e0n<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">S\u1ed1 \u00e2m \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 s\u1ed1 d\u01b0\u01a1ng nh\u01b0ng \u0111\u01b0\u1ee3c \u0111\u1eb7t \u1edf trong ngo\u1eb7c<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">S\u00f4 0 \u0111\u01b0\u1ee3c vi\u1ebft d\u01b0\u1edbi d\u1ea1ng m\u1ed9t d\u1ea5u g\u1ea1ch n\u1ed1i<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">D\u1eef li\u1ec7u text \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u t\u00edm.<\/span><\/li>\n<\/ol>\n<blockquote>\n<p>C\u00f3 th\u1ec3 b\u1ea1n quan t\u00e2m:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">Kho\u0301a ho\u0323c l\u00e2\u0323p tri\u0300nh VBA trong excel<\/a><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Nhung_luu_y\"><\/span>Nh\u1eefng l\u01b0u \u00fd:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Tr\u01b0\u1edbc khi t\u00ecm hi\u1ec3u l\u00e0m sao \u0111\u1ec3 t\u1ea1o ra \u0111\u01b0\u1ee3c m\u1ed9t \u0111\u1ecbnh d\u1ea1ng nh\u01b0 v\u1eady, ch\u00fang ta c\u00f3 1 v\u00e0i l\u01b0u \u00fd sau \u0111\u00e2y<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ecbnh d\u1ea1ng ch\u1ec9 thay \u0111\u1ed5i nh\u1eefng g\u00ec ch\u00fang ta nh\u00ecn th\u1ea5y tr\u00ean m\u00e0n h\u00ecnh, n\u1ed9i dung th\u1ef1c s\u1ef1 \u0111\u01b0\u1ee3c l\u01b0u trong b\u1ea3ng d\u1eef li\u1ec7u Excel kh\u00f4ng thay \u0111\u1ed5i<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Khi c\u00e1c b\u1ea1n s\u1eeda nh\u1eefng \u0111\u1ecbnh d\u1ea1ng c\u00f3 s\u1eb5n c\u1ee7a Excel, nh\u1eefng \u0111\u1ecbnh d\u1ea1ng n\u00e0y kh\u00f4ng b\u1ecb m\u1ea5t \u0111i hay ghi \u0111\u00e8 l\u00ean, v\u1eady n\u00ean, h\u00e3y d\u0169ng c\u1ea3m th\u1eed nh\u1eefng \u0111\u1ecbnh d\u1ea1ng t\u1ef1 m\u00ecnh t\u1ea1o ra<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ecbnh d\u1ea1ng do b\u1ea1n b\u1ea1n t\u1ea1o ra kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i c\u00f3 c\u1ea3 4 ph\u1ea7n<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng m\u1eb7c \u0111\u1ecbnh c\u1ee7a Excel cho ph\u1ea7n n\u00e0o trong 4 ph\u1ea7n \u0111\u00e3 n\u00f3i \u1edf tr\u00ean, ch\u00fang ta ch\u1ec9 c\u1ea7n vi\u1ebft v\u00e0o ph\u1ea7n \u0111\u00f3 ki\u1ec3u General. VD. Mu\u1ed1n s\u1ed1 0 s\u1ebd \u0111\u01b0\u1ee3c vi\u1ebft b\u1eb1ng d\u1ea5u g\u1ea1ch n\u1ed1i \u2013 , s\u1ed1 d\u01b0\u01a1ng, s\u1ed1 \u00e2m v\u00e0 text \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng m\u1eb7c \u0111\u1ecbnh th\u00ec ch\u00fang ta d\u00f9ng m\u00e3 \u0111\u1ecbnh d\u1ea1ng sau \u0111\u00e2y General;-General;\u201d-\u201d;General<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ec3 \u1ea9n m\u1ed9t gi\u00e1 tr\u1ecb trong 4 ph\u1ea7n tr\u00ean, ch\u00fang ta ch\u1ec9 c\u1ea7n b\u1ecf qua \u0111\u1ecbnh d\u1ea1ng cho ph\u1ea7n t\u01b0\u01a1ng \u1ee9ng \u0111\u00f3. VD. N\u1ebfu ch\u00fang ta kh\u00f4ng mu\u1ed1n hi\u1ec3n th\u1ecb s\u1ed1 0, th\u00ec m\u00e3 \u0111\u1ecbnh d\u1ea1ng s\u1ebd nh\u01b0 sau General;-General;;General<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1eefng \u0111\u1ecbnh d\u1ea1ng m\u00e0 b\u1ea1n t\u1ea1o ra, c\u00f3 hi\u1ec7u l\u1ef1c trong 1 t\u00e0i li\u1ec7u Excel hi\u1ec7n th\u1eddi m\u00e0 th\u00f4i<\/span><\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Y_nghia_cua_cac_ki_tu_trong_ma_dinh_dang\"><\/span><span style=\"font-weight: 400\">\u00dd ngh\u0129a c\u1ee7a c\u00e1c k\u00ed t\u1ef1 trong m\u00e3 \u0111\u1ecbnh d\u1ea1ng:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<table class=\"blog-table\" style=\"height: 456px\" border=\"0\" width=\"750\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr class=\"head even\" style=\"height: 24px\">\n<td style=\"height: 24px;width: 66px\"><strong>Code<\/strong><\/td>\n<td style=\"height: 24px;width: 330px\"><b>Mi\u00eau t\u1ea3<\/b><\/td>\n<td style=\"height: 24px;width: 346px\"><b>V\u00ed d\u1ee5<\/b><\/td>\n<\/tr>\n<tr style=\"height: 128px\">\n<td style=\"height: 128px;width: 66px\">0<\/td>\n<td style=\"height: 128px;width: 330px\">Hi\u1ec3n th\u1ecb ch\u1eef s\u1ed1 0, k\u1ec3 c\u1ea3 nh\u1eefng s\u1ed1 0 kh\u00f4ng c\u1ea7n thi\u1ebft, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n n\u1ebfu c\u1ea7n.<\/td>\n<td style=\"height: 128px;width: 346px\">#.00 \u2013 lu\u00f4n hi\u1ec3n th\u1ecb 2 ch\u1eef s\u1ed1 sau d\u1ea5u ph\u1ea9y, bao g\u1ed3m c\u1ea3 s\u1ed5 0VD: n\u1ebfu b\u1ea1n \u0111\u00e1nh 5.5 v\u00e0o 1 \u00f4, Excel s\u1ebd \u0111\u1ecbnh d\u1ea1ng th\u00e0nh 5.50<\/td>\n<\/tr>\n<tr class=\"even\" style=\"height: 192px\">\n<td style=\"height: 192px;width: 66px\">#<\/td>\n<td style=\"height: 192px;width: 330px\">Ch\u1ec9 hi\u1ec3n th\u1ecb nh\u1eefng ch\u1eef s\u1ed1 c\u1ea7n thi\u1ebft, s\u1ed1 0 \u1edf cu\u1ed1i s\u1ebd b\u1ecb b\u1ecf qua, s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n n\u1ebfu c\u1ea7n<\/td>\n<td style=\"height: 192px;width: 346px\">#.## \u2013 hi\u1ec3n th\u1ecb <strong>\u0111\u1ebfn<\/strong> 2 ch\u1eef s\u1ed1 sau d\u1ea5u ph\u1ea9y<\/p>\n<p>VD: N\u1ebfu b\u1ea1n nh\u1eadp v\u00e0o 1 \u00f4 trong Excel l\u00e0 5.5 th\u00ec v\u1edbi \u0111\u1ecbnh d\u1ea1ng n\u00e0y, Excel s\u1ebd hi\u1ec3n th\u1ecb l\u00e0 5.5 m\u00e0 th\u00f4i.<\/p>\n<p>N\u1ebfu 5.555 \u0111\u01b0\u1ee3c g\u00f5 v\u00e0o 1 \u00f4, th\u00ec Excel s\u1ebd hi\u1ec3n th\u1ecb l\u00e0 5.56 (l\u00e0m tr\u00f2n)<\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 72px\">\n<td style=\"height: 72px;width: 66px\">?<\/td>\n<td style=\"height: 72px;width: 330px\">S\u1eed d\u1ee5ng khi c\u1ea7n d\u00f3ng th\u1eb3ng h\u00e0ng c\u00e1c con s\u1ed1 theo d\u1ea5u th\u1eadp ph\u00e2n<\/td>\n<td style=\"height: 72px;width: 346px\">#.??? \u2013 Hi\u1ec3n th\u1ecb t\u1ed1i \u0111a \u0111\u1ebfn 3 ch\u1eef s\u1ed1 sau d\u1ea5u ph\u1ea9y, n\u1ebfu \u00edt h\u01a1n 3 ch\u1eef s\u1ed1, c\u00e1c con s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c c\u0103n th\u1eb3ng h\u00e0ng theo d\u1ea5u ph\u1ea9y<\/td>\n<\/tr>\n<tr class=\"even\" style=\"height: 48.8594px\">\n<td style=\"height: 48.8594px;width: 66px\">@<\/td>\n<td style=\"height: 48.8594px;width: 330px\">Thay th\u1ebf cho d\u1eef li\u1ec7u ki\u1ec3u Text<\/td>\n<td style=\"height: 48.8594px;width: 346px\">0.00; -0.00; 0; [Red]@ \u2013 N\u1ebfu \u00f4 v\u1edbi \u0111\u1ecbnh d\u1ea1ng nh\u01b0 th\u1ebf n\u00e0y s\u1ebd hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u text m\u00e0u \u0111\u1ecf<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><span class=\"ez-toc-section\" id=\"_Mot_so_vi_du\"><\/span>\u00a0M\u1ed9t s\u1ed1 v\u00ed d\u1ee5:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Custom_format_co_ban\"><\/span>Custom format c\u01a1 b\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-custom-number-format.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-574\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-custom-number-format.png\" alt=\"excel-custom-number-format\" width=\"403\" height=\"142\" title=\"excel-custom-number-format\"><\/a><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean<\/p>\n<ul>\n<li>C\u1ed9t 1 l\u00e0 \u0111\u1ecbnh d\u1ea1ng m\u1eb7c \u0111\u1ecbnh c\u1ee7a Excel<\/li>\n<li>C\u1ed9t th\u1ee9 2 c\u00f3 \u0111\u1ecbnh d\u1ea1ng custom l\u00e0 #.00 c\u00f3 \u00fd ngh\u0129a: lu\u00f4n hi\u1ec3n th\u1ecb 2 ch\u1eef s\u1ed1 \u0111\u1eb1ng sau d\u1ea5u th\u1eadp ph\u00e2n d\u00f9 ch\u1eef s\u1ed1 \u0111\u00f3 c\u00f3 l\u00e0 s\u1ed1 0 \u0111i n\u1eefa, c\u00e1c s\u1ed1 th\u1eeba ra s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n theo quy t\u1eafc.<\/li>\n<li>C\u1ed9t th\u1ee9 3 c\u00f3 \u0111\u1ecbnh d\u1ea1ng custom l\u00e0 #.## c\u00f3 \u00fd ngh\u0129a: hi\u1ec7n th\u1ecb t\u1edbi 2 ch\u1eef s\u1ed1 \u0111\u1eb1ng sau d\u1ea5u th\u1eadp ph\u00e2n, b\u1ecf qua s\u1ed1 0, c\u00e1c s\u1ed1 th\u1eeba ra s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n theo quy t\u1eafc.<\/li>\n<li>C\u1ed9t th\u1ee9 4 c\u00f3 \u0111\u1ecbnh d\u1ea1ng customer l\u00e0 #.??? c\u00f3 \u00fd ngh\u0129a: hi\u1ec3n th\u1ecb t\u1edbi 3 ch\u1eef s\u1ed1 sau d\u1ea5u ph\u1ea9y, c\u0103n th\u1eb3ng h\u00e0ng v\u1edbi c\u00e1c d\u00f2ng c\u00f3 c\u00f9ng \u0111\u1ecbnh d\u1ea1ng b\u1edfi d\u1ea5u th\u1eadp ph\u00e2n<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Custom_format_thay_the_000_bang_K\"><\/span>Custom format thay th\u1ebf 000 b\u1eb1ng K<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/07\/Screen-Shot-2016-07-12-at-23.17.59.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-575 size-medium\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-07-12-at-23-17-59-300x169-1.png\" alt=\"Screen Shot 2016-07-12 at 23.17.59\" width=\"300\" height=\"169\" title=\"screen-shot-2016-07-12-at-23-17-59-300x169-1\"><\/a><\/p>\n<p>Trong h\u00ecnh minh ho\u1ea1 tr\u00ean: c\u00e1c s\u1ed1 nh\u1ecf h\u01a1n 1000 s\u1ebd \u0111\u01b0\u1ee3c Excel hi\u1ec3n th\u1ecb b\u00ecnh th\u01b0\u1eddng, s\u1ed1 0 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb b\u1eb1ng 0, c\u00e1c s\u1ed1 l\u1edbn h\u01a1n 1000 s\u1ebd \u0111\u01b0\u1ee3c c\u1eaft \u0111i 3 s\u1ed1 0 \u1edf cu\u1ed1i v\u00e0 thay b\u1eb1ng ch\u1eef K. M\u1ed9t s\u1ed1 v\u00ed d\u1ee5 kh\u00e1c nh\u01b0 h\u00ecnh minh ho\u1ea1 sau \u0111\u00e2y:<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/07\/Screen-Shot-2016-07-12-at-23.22.03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-576\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-07-12-at-23-22-03-1024x495-1.png\" alt=\"Screen Shot 2016-07-12 at 23.22.03\" width=\"1024\" height=\"495\" title=\"screen-shot-2016-07-12-at-23-22-03-1024x495-1\"><\/a><\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady khi l\u00e0m tr\u00f2n \u0111\u1ebfn h\u00e0ng tri\u1ec7u v\u1edbi ch\u1eef M<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/07\/Screen-Shot-2016-07-12-at-23.23.41.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-577\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-07-12-at-23-23-41-1024x695-1.png\" alt=\"Screen Shot 2016-07-12 at 23.23.41\" width=\"1024\" height=\"695\" title=\"screen-shot-2016-07-12-at-23-23-41-1024x695-1\"><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cac_vi_du_ve_Custom_format_voi_chu_mau_va_dieu_kien\"><\/span>C\u00e1c v\u00ed d\u1ee5 v\u1ec1 Custom format v\u1edbi ch\u1eef, m\u00e0u v\u00e0 \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/07\/Screen-Shot-2016-07-12-at-23.25.04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-578\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-07-12-at-23-25-04-1024x422-1.png\" alt=\"Screen Shot 2016-07-12 at 23.25.04\" width=\"1024\" height=\"422\" title=\"screen-shot-2016-07-12-at-23-25-04-1024x422-1\"><\/a><\/p>\n<p>Trong 2 v\u00ed d\u1ee5 tr\u00ean, v\u1edbi custom format code theo th\u1ee9 t\u1ef1 <strong>&lt;s\u1ed1 d\u01b0\u01a1ng&gt;;&lt;s\u1ed1 \u00e2m&gt;;&lt;s\u1ed1 0&gt;; <\/strong>c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng nh\u1eadn th\u1ea5y quy lu\u1eadt \u1edf \u0111\u00e2y: T\u0103ng s\u1ebd \u0111i v\u1edbi s\u1ed1 d\u01b0\u01a1ng, gi\u1ea3m \u0111i v\u1edbi s\u1ed1 \u00e2m, s\u1ed1 0 th\u00ec \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_custom_format_voi_ki_tu_dac_biet_%E2%80%93_%E2%80%9D%C2%B0C%E2%80%9D\"><\/span>S\u1eed d\u1ee5ng custom format v\u1edbi k\u00ed t\u1ef1 \u0111\u1eb7c bi\u1ec7t \u2013 \u00a0#\u201d\u00b0C\u201d<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-07-12-at-23-34-09.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-579 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-07-12-at-23-34-09.png\" alt=\"Screen Shot 2016-07-12 at 23.34.09\" width=\"966\" height=\"302\" title=\"screen-shot-2016-07-12-at-23-34-09\"><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_custom_format_de_dua_ra_thong_diep\"><\/span>S\u1eed d\u1ee5ng custom format \u0111\u1ec3 \u0111\u01b0a ra th\u00f4ng \u0111i\u1ec7p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>K\u1ef9 thu\u1eadt n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong vi\u1ec7c <a href=\"https:\/\/blog.hocexcel.online\/dashboard-bao-cao-doanh-thu-tuong-tac-bang-slicer-va-pivot.html\">t\u1ea1o Dashboard<\/a>, trong b\u00e0i n\u00e0y ch\u00fang ta s\u1ebd kh\u00f4ng t\u1ea1o dashboard m\u00e0 d\u00f9ng custom format code sau \u0111\u00e2y:<\/p>\n<p><strong>[Magenta][&lt;=18] \u201cH\u00f4m nay\u201d # \u201c\u0111\u1ed9. Em m\u1eb7c \u1ea5m nh\u00e9\u201d;#\u201d \u0111\u1ed9\u201d;#\u201d \u0111\u1ed9\u201d<\/strong><\/p>\n<p>v\u00e0 k\u1ebft qu\u1ea3 nh\u01b0 sau<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-07-12-at-23-38-18.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-580 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-07-12-at-23-38-18.png\" alt=\"Screen Shot 2016-07-12 at 23.38.18\" width=\"874\" height=\"316\" title=\"screen-shot-2016-07-12-at-23-38-18\"><\/a><\/p>\n<p>2 \u00f4 ch\u1ee9a nhi\u1ec7t \u0111\u1ed9 c\u1ee7a H\u00e0 N\u1ed9i v\u00e0 Th\u00e1i Nguy\u00ean \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng v\u1edbi custom format code, c\u1ee9 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 18 \u0111\u1ed9 th\u00ec ch\u1eef s\u1ebd \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u t\u00edm v\u00e0 c\u00f3 th\u00f4ng \u0111i\u1ec7p nh\u01b0 tr\u00ean.<\/p>\n<p>C\u00e1c m\u00e0u \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 l\u00e0:<\/p>\n<ul>\n<li>[Black]<\/li>\n<li>[Green]<\/li>\n<li>[White]<\/li>\n<li>[Blue]<\/li>\n<li>[Magenta]<\/li>\n<li>[Yellow]<\/li>\n<li>[Cyan]<\/li>\n<li>[Red]<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Dung_custom_format_de_chen_so_0_dang_truoc_cac_so_khac\"><\/span>D\u00f9ng custom format \u0111\u1ec3 ch\u00e8n s\u1ed1 0 \u0111\u1eb1ng tr\u01b0\u1edbc c\u00e1c s\u1ed1 kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00f4i khi ch\u00fang ta c\u00f3 c\u1ed9t ID c\u00f3 6 s\u1ed1 ch\u1eb3ng h\u1ea1n, ch\u00fang ta mu\u1ed1n c\u1ed9t n\u00e0y \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb theo \u0111\u1ecbnh d\u1ea1ng 000001, 000002, 0000003, \u2026 ch\u1eb3ng h\u1ea1n th\u00ec \u0111\u1ecbnh d\u1ea1ng <strong>000000<\/strong>\u00a0s\u1ebd gi\u00fap b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-07-12-at-23-41-58.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-581 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-07-12-at-23-41-58.png\" alt=\"Screen Shot 2016-07-12 at 23.41.58\" width=\"906\" height=\"290\" title=\"screen-shot-2016-07-12-at-23-41-58\"><\/a><\/p>\n<p>C\u00f3 1 \u0111\u1ecbnh d\u1ea1ng \u0111\u1eb7c bi\u1ec7t trong Excel v\u1edbi custom format code c\u00e1c b\u1ea1n n\u00ean th\u1eed nh\u01b0 sau. Sau khi \u0111\u1ecbnh d\u1ea1ng nh\u01b0 v\u1eady r\u1ed3i, c\u00e1c b\u1ea1n th\u1eed thay \u0111\u1ed5i \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t xem \ud83d\ude42<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/07\/Screen-Shot-2016-07-12-at-23.43.37.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-582\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-07-12-at-23-43-37-1024x227-1.png\" alt=\"Screen Shot 2016-07-12 at 23.43.37\" width=\"1024\" height=\"227\" title=\"screen-shot-2016-07-12-at-23-43-37-1024x227-1\"><\/a><\/p>\n<p>Download file th\u1ef1c h\u00e0nh t\u1ea1i \u0111\u00e2y:<\/p>\n<p>[sociallocker id=457]<\/p>\n<p><a href=\"http:\/\/bit.ly\/dtnEX100\">Download<\/a><\/p>\n<p>[\/sociallocker]<\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra \u0111\u1ec3 n\u00e2ng cao h\u01a1n ki\u1ebfn th\u1ee9c v\u1ec1 Excel, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham gia kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2vgkTxB\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Trong kh\u00f3a h\u1ecdc n\u00e0y c\u00e1c b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ecm hi\u1ec3u nh\u1eefng ki\u1ebfn th\u1ee9c \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, vi\u1ec7c \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m, c\u00f4ng c\u1ee5 \u0111\u00f3 v\u00e0o trong c\u00f4ng vi\u1ec7c. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng c\u00f3 r\u1ea5t nhi\u1ec1u \u01b0u \u0111\u00e3i cho b\u1ea1n khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: justify\">\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-141.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1912,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1911","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\/1911","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=1911"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1911\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1912"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}