{"id":4505,"date":"2024-12-06T10:22:33","date_gmt":"2024-12-06T10:22:33","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/06\/custom-format-va-nhung-ap-dung-huu-ich\/"},"modified":"2024-12-06T10:22:33","modified_gmt":"2024-12-06T10:22:33","slug":"custom-format-va-nhung-ap-dung-huu-ich","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/06\/custom-format-va-nhung-ap-dung-huu-ich\/","title":{"rendered":"Custom Format v\u00e0 nh\u1eefng \u00e1p d\u1ee5ng h\u1eefu \u00edch"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\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-6752d06819bfe\" 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\/custom-format-va-nhung-ap-dung-huu-ich.html#Custom_Format_la_gi\" title=\"Custom Format l\u00e0 g\u00ec?\">Custom Format l\u00e0 g\u00ec?<\/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\/custom-format-va-nhung-ap-dung-huu-ich.html#Cu_phap_can_ban_cua_Custom_Format\" title=\"C\u00fa ph\u00e1p c\u0103n b\u1ea3n c\u1ee7a Custom Format.\">C\u00fa ph\u00e1p c\u0103n b\u1ea3n c\u1ee7a Custom Format.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/custom-format-va-nhung-ap-dung-huu-ich.html#Custom_Format_lam_nhung_gi\" title=\"Custom Format l\u00e0m nh\u1eefng g\u00ec?\">Custom Format l\u00e0m nh\u1eefng g\u00ec?<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/custom-format-va-nhung-ap-dung-huu-ich.html#Cach_dinh_dang_ngay_thang_nam_voi_Custom_Format\" title=\"C\u00e1ch \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m v\u1edbi Custom Format.\">C\u00e1ch \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m v\u1edbi Custom Format.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/custom-format-va-nhung-ap-dung-huu-ich.html#Cach_nhanh_nhat_de_viet_ra_thu_trong_tuan_tu_ngay_cho_truoc\" title=\"C\u00e1ch\u00a0nhanh nh\u1ea5t \u0111\u1ec3 vi\u1ebft ra th\u1ee9 trong tu\u1ea7n t\u1eeb ng\u00e0y cho tr\u01b0\u1edbc.\">C\u00e1ch\u00a0nhanh nh\u1ea5t \u0111\u1ec3 vi\u1ebft ra th\u1ee9 trong tu\u1ea7n t\u1eeb ng\u00e0y cho tr\u01b0\u1edbc.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/custom-format-va-nhung-ap-dung-huu-ich.html#Cach_hien_thi_ngay_thang_nam_bang_tieng_Viet_voi_Custom_Format\" title=\"C\u00e1ch hi\u1ec3n th\u1ecb ng\u00e0y th\u00e1ng n\u0103m b\u1eb1ng ti\u1ebfng Vi\u1ec7t v\u1edbi Custom Format.\">C\u00e1ch hi\u1ec3n th\u1ecb ng\u00e0y th\u00e1ng n\u0103m b\u1eb1ng ti\u1ebfng Vi\u1ec7t v\u1edbi Custom Format.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/custom-format-va-nhung-ap-dung-huu-ich.html#Cach_de_viet_cum_tu_%E2%80%9CNgay%E2%80%9D_%E2%80%9Cthang%E2%80%9D_%E2%80%9Cnam%E2%80%9D_trong_Custom_Format\" title=\"C\u00e1ch \u0111\u1ec3 vi\u1ebft c\u1ee5m t\u1eeb \u201cNg\u00e0y\u201d, \u201cth\u00e1ng\u201d, \u201cn\u0103m\u201d trong Custom Format.\">C\u00e1ch \u0111\u1ec3 vi\u1ebft c\u1ee5m t\u1eeb \u201cNg\u00e0y\u201d, \u201cth\u00e1ng\u201d, \u201cn\u0103m\u201d trong Custom Format.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/custom-format-va-nhung-ap-dung-huu-ich.html#Cach_hien_thi_so_Chung_minh_nhan_dan_9_so_va_Can_cuoc_cong_dan_12_so_trong_Excel\" title=\"C\u00e1ch hi\u1ec3n th\u1ecb s\u1ed1 Ch\u1ee9ng minh nh\u00e2n d\u00e2n (9 s\u1ed1) v\u00e0 C\u0103n c\u01b0\u1edbc c\u00f4ng d\u00e2n (12 s\u1ed1) trong Excel.\">C\u00e1ch hi\u1ec3n th\u1ecb s\u1ed1 Ch\u1ee9ng minh nh\u00e2n d\u00e2n (9 s\u1ed1) v\u00e0 C\u0103n c\u01b0\u1edbc c\u00f4ng d\u00e2n (12 s\u1ed1) trong Excel.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/custom-format-va-nhung-ap-dung-huu-ich.html#Cong_thuc_tinh_tuoi_trong_Excel\" title=\"C\u00f4ng th\u1ee9c t\u00ednh tu\u1ed5i trong Excel\">C\u00f4ng th\u1ee9c t\u00ednh tu\u1ed5i trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/custom-format-va-nhung-ap-dung-huu-ich.html#Cach_hien_thi_so_0_o_so_dien_thoai_10_%E2%80%93_11_so_trong_Excel\" title=\"C\u00e1ch hi\u1ec3n th\u1ecb s\u1ed1 0 \u1edf s\u1ed1 \u0111i\u1ec7n tho\u1ea1i 10 \u2013 11 s\u1ed1 trong Excel.\">C\u00e1ch hi\u1ec3n th\u1ecb s\u1ed1 0 \u1edf s\u1ed1 \u0111i\u1ec7n tho\u1ea1i 10 \u2013 11 s\u1ed1 trong Excel.<\/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-11\" href=\"https:\/\/blog.hocexcel.online\/custom-format-va-nhung-ap-dung-huu-ich.html#Ket_hop_giua_ham_TEXT_va_CUSTOM_FORMAT\" title=\"K\u1ebft h\u1ee3p gi\u1eefa h\u00e0m TEXT v\u00e0 CUSTOM FORMAT\">K\u1ebft h\u1ee3p gi\u1eefa h\u00e0m TEXT v\u00e0 CUSTOM FORMAT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/custom-format-va-nhung-ap-dung-huu-ich.html#Ket_hop_CUSTOM_FORMAT_voi_CONDITIONAL_FORMATTING\" title=\"K\u1ebft h\u1ee3p CUSTOM FORMAT v\u1edbi CONDITIONAL FORMATTING.\">K\u1ebft h\u1ee3p CUSTOM FORMAT v\u1edbi CONDITIONAL FORMATTING.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/custom-format-va-nhung-ap-dung-huu-ich.html#Lam_the_nao_de_co_duoc_cac_ky_tu_dac_biet_nhu_%E2%96%B2%E2%96%BC_trong_Custom_Format\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t nh\u01b0: \u25b2\u25bc trong Custom Format?\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t nh\u01b0: \u25b2\u25bc trong Custom Format?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/custom-format-va-nhung-ap-dung-huu-ich.html#Ap_dung_CUSTOM_FORMAT_cho_FIELD_CODE_trong_Mail_Merge\" title=\"\u00c1p d\u1ee5ng CUSTOM FORMAT cho FIELD CODE trong Mail Merge.\">\u00c1p d\u1ee5ng CUSTOM FORMAT cho FIELD CODE trong Mail Merge.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/custom-format-va-nhung-ap-dung-huu-ich.html#Dinh_dang_to_mau_sac_trong_CUSTOM_FORMAT\" title=\"\u0110\u1ecbnh d\u1ea1ng t\u00f4 m\u00e0u s\u1eafc trong CUSTOM FORMAT\">\u0110\u1ecbnh d\u1ea1ng t\u00f4 m\u00e0u s\u1eafc trong CUSTOM FORMAT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/custom-format-va-nhung-ap-dung-huu-ich.html#Cac_phim_tat_thong_dung_dung_de_dinh_dang_trong_Excel\" title=\"C\u00e1c ph\u00edm t\u1eaft th\u00f4ng d\u1ee5ng d\u00f9ng \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng trong Excel\">C\u00e1c ph\u00edm t\u1eaft th\u00f4ng d\u1ee5ng d\u00f9ng \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Custom_Format_la_gi\"><\/span>Custom Format l\u00e0 g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Custom Format gi\u1ed1ng nh\u01b0 vi\u1ec7c b\u1ea1n trang \u0111i\u1ec3m, m\u1eb7c qu\u1ea7n \u00e1o theo c\u00e1c ki\u1ec3u phong c\u00e1ch kh\u00e1c nhau. Nh\u01b0ng b\u1ea3n ch\u1ea5t, b\u1ea1n v\u1eabn l\u00e0 ch\u00ednh b\u1ea1n. V\u00e0 Custom Format g\u1ecdi ch\u00ednh x\u00e1c s\u1ebd l\u00e0 Custom Number Format (\u0111\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh d\u00e0nh cho s\u1ed1). R\u1ea5t nhi\u1ec1u b\u1ea1n l\u1ea7m t\u01b0\u1edfng Custom Format s\u1ebd gi\u00fap b\u1ea1n thay \u0111\u1ed5i b\u1ea3n ch\u1ea5t d\u1eef li\u1ec7u. Nh\u01b0ng th\u1ef1c t\u1ebf kh\u00f4ng ph\u1ea3i v\u1eady. B\u1ea3n ch\u1ea5t d\u1eef li\u1ec7u l\u00e0 TEXT th\u00ec kh\u00f4ng th\u1ec3 chuy\u1ec3n th\u00e0nh s\u1ed1 th\u00f4ng qua Custom Format. Ph\u1ea3i ti\u1ebfn h\u00e0nh \u0111i Th\u00e1i Lan, \u00e0 m\u00ecnh nh\u1ea7m, l\u00e0 chuy\u1ec3n \u0111\u1ed5i. T\u01b0\u01a1ng t\u1ef1, n\u1ebfu mu\u1ed1n d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1, chuy\u1ec3n sang ch\u1eef ch\u00fang ta c\u0169ng ph\u1ea3i \u00e1p d\u1ee5ng chuy\u1ec3n \u0111\u1ed5i.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cu_phap_can_ban_cua_Custom_Format\"><\/span>C\u00fa ph\u00e1p c\u0103n b\u1ea3n c\u1ee7a Custom Format.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Custom Format bao g\u1ed3m 4 ph\u1ea7n c\u0103n b\u1ea3n nh\u01b0 sau, ng\u0103n c\u00e1ch gi\u1eefa 4 ph\u1ea7n l\u00e0 d\u1ea5u ch\u1ea5m ph\u1ea9y \u201c;\u201d.<\/p>\n<ul>\n<li>S\u1ed1 d\u01b0\u01a1ng ho\u1eb7c \u0111i\u1ec1u ki\u1ec7n logic [&gt;=S\u1ed1]:\u00a0S\u1ed1 l\u1edbn h\u01a1n 0 ho\u1eb7c theo bi\u1ec3u th\u1ee9c logic.<\/li>\n<li>S\u1ed1 \u00e2m ho\u1eb7c \u0111i\u1ec1u ki\u1ec7n logic [&lt;=S\u1ed1]: S\u1ed1 nh\u1ecf h\u01a1n 0 ho\u1eb7c theo bi\u1ec3u th\u1ee9c logic<\/li>\n<li>S\u1ed1 0<\/li>\n<li>Ch\u1eef<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/cu-phap-custom-number-format-cells.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24038\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cu-phap-custom-number-format-cells.jpg\" width=\"749\" height=\"126\" title=\"cu-phap-custom-number-format-cells\"><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Custom_Format_lam_nhung_gi\"><\/span>Custom Format l\u00e0m nh\u1eefng g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"Cach_dinh_dang_ngay_thang_nam_voi_Custom_Format\"><\/span>C\u00e1ch \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m v\u1edbi Custom Format.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>d\/m\/yy: Vi\u1ebft t\u1eaft theo ng\u00e0y\/th\u00e1ng\/n\u0103m. N\u1ebfu s\u1ed1 nh\u1ecf h\u01a1n 10, th\u00ec kh\u00f4ng c\u00f3 s\u1ed1 0 \u0111\u1eb1ng tr\u01b0\u1edbc.<br \/>\nV\u00ed d\u1ee5: 30\/11\/18 ho\u1eb7c 5\/2\/19.<\/li>\n<li>dd\/mm\/yyyy: Vi\u1ebft \u0111\u1ea7y \u0111\u1ee7 theo ng\u00e0y\/th\u00e1ng\/n\u0103m. N\u1ebfu s\u1ed1 nh\u1ecf h\u01a1n 10, s\u1ebd c\u00f3 s\u1ed1 0 \u0111\u1eb1ng tr\u01b0\u1edbc. V\u00ed d\u1ee5: 08\/03\/2017 ho\u1eb7c 05\/02\/2019.<\/li>\n<li>dd\/mmm\/yyyy:\u00a0Th\u00e1ng vi\u1ebft d\u1ea1ng ch\u1eef vi\u1ebft t\u1eaft, v\u00ed d\u1ee5: 05\/Feb\/2019.<\/li>\n<li>dd mmmm yyyy: Th\u00e1ng vi\u1ebft d\u1ea1ng ch\u1eef vi\u1ebft \u0111\u1ee7, v\u00ed d\u1ee5: 05 February 2019<\/li>\n<li>ddd, mmm dd, yyyy: Ng\u00e0y v\u00e0 th\u00e1ng d\u1ea1ng ch\u1eef vi\u1ebft t\u1eaft, v\u00ed d\u1ee5:\u00a0Tue,\u00a0Feb\u00a005,\u00a02019<\/li>\n<li>dddd, mmmm dd, yyyy: Ng\u00e0y th\u00e1ng vi\u1ebft \u0111\u1ea7y \u0111\u1ee7, v\u00ed d\u1ee5: Tuesday, February 04,\u00a02019<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24042 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-format-date.jpg\" width=\"382\" height=\"166\" title=\"custom-format-date\"><\/p>\n<ul>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"Cach_nhanh_nhat_de_viet_ra_thu_trong_tuan_tu_ngay_cho_truoc\"><\/span>C\u00e1ch\u00a0nhanh nh\u1ea5t \u0111\u1ec3 vi\u1ebft ra th\u1ee9 trong tu\u1ea7n t\u1eeb ng\u00e0y cho tr\u01b0\u1edbc.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>B\u1ea1n c\u00f3 th\u1ec3 l\u1eadp m\u1ed9t b\u1ea3ng ch\u1ea5m c\u00f4ng v\u00e0 hi\u1ec3n th\u1ecb c\u00e1c Th\u1ee9 c\u1ee7a ng\u00e0y trong tu\u1ea7n tr\u00ean b\u1ea3ng ch\u1ea5m c\u00f4ng, c\u0169ng nh\u01b0 \u00e1p d\u1ee5ng h\u00e0m WEEKDAY \u0111\u1ec3 t\u00ecm ra ng\u00e0y cu\u1ed1i tu\u1ea7n d\u1ec5 d\u00e0ng nh\u01b0 sau.<\/li>\n<li>B\u1ea3n th\u00e2n d\u1eef li\u1ec7u ng\u00e0y c\u00e1c d\u00f2ng 3 v\u00e0 9, c\u00e1c b\u1ea1n th\u1ea5y n\u00f3 ch\u1ec9 c\u00f3 2 ch\u1eef s\u1ed1 d\u1ea1ng ng\u00e0y \u201cdd\u201d, nh\u01b0ng th\u1ef1c ch\u1ea5t \u0111\u00f3 l\u00e0 1 ng\u00e0y ch\u00ednh x\u00e1c. V\u00e0 t\u1eeb d\u1eef li\u1ec7u ng\u00e0y ch\u00ednh x\u00e1c ch\u00fang ta m\u1edbi c\u00f3 th\u1ec3 l\u00e0m c\u00e1c ph\u00e9p t\u00ednh to\u00e1n, v\u1eadn d\u1ee5ng c\u00e1c h\u00e0m li\u00ean quan.<\/li>\n<li>Ri\u00eang v\u1ec1 h\u00e0m SEQUENCE l\u00e0 h\u00e0m m\u1edbi c\u1ee7a Excel 365, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra 1 d\u00e3y s\u1ed1 li\u00ean t\u1ee5c v\u1edbi c\u00e1c h\u00e0m s\u1ed1 SEQUENCE(s\u1ed1 d\u00f2ng, s\u1ed1 c\u1ed9t, [gi\u00e1 tr\u1ecb b\u1eaft \u0111\u1ea7u], [b\u01b0\u1edbc t\u0103ng]).<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/date-custom-format-weekday-day.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24043\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/date-custom-format-weekday-day.jpg\" width=\"1273\" height=\"433\" title=\"date-custom-format-weekday-day\"><\/a><\/li>\n<li>H\u00e0m WEEKDAY(Ng\u00e0y, tham s\u1ed1 tr\u1ea3 v\u1ec1). V\u1edbi tham s\u1ed1 l\u00e0 1: T\u01b0\u01a1ng \u1ee9ng 1-Ch\u1ee7 nh\u1eadt, 2-Th\u1ee9 2\u2026 7-Th\u1ee9 7. V\u1edbi tham s\u1ed1 l\u00e0 2: 1-Th\u1ee9 2, 2-Th\u1ee9 3,\u2026 6-Th\u1ee9 7, 7-Ch\u1ee7 nh\u1eadt. B\u1ea1n s\u1ebd g\u1eb7p tham s\u1ed1 2, khi c\u1ea7n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng t\u00f4 m\u00e0u theo \u0111i\u1ec1u ki\u1ec7n cho 2 ng\u00e0y cu\u1ed1i tu\u1ea7n. V\u00ed d\u1ee5: =WEEKDAY(Ng\u00e0y,2)&gt;5<\/li>\n<\/ul>\n<\/li>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"Cach_hien_thi_ngay_thang_nam_bang_tieng_Viet_voi_Custom_Format\"><\/span>C\u00e1ch hi\u1ec3n th\u1ecb ng\u00e0y th\u00e1ng n\u0103m b\u1eb1ng ti\u1ebfng Vi\u1ec7t v\u1edbi Custom Format.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>T\u00f9y ch\u1ecdn Locale trong Custom: V\u1edbi Office 2007 tr\u1edf \u0111i, b\u1ea1n c\u00f3 th\u1ec3 v\u00e0o Custom Format, sau \u0111\u00f3 ch\u1ecdn Date =&gt; R\u1ed3i ch\u1ecdn Locale l\u00e0 Vietnamese, r\u1ed3i ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng b\u1ea5t k\u1ef3. Sau \u0111\u00f3 v\u00e0o Custom, b\u1ea1n s\u1ebd th\u1ea5y d\u1ea5u [$-m\u00e3 locale] hi\u1ec7n ra, \u0111\u1ec3 t\u00f9y ch\u1ec9nh Locale c\u1ee7a Custom Format theo qu\u1ed1c gia t\u00f9y ch\u1ecdn.<\/li>\n<li>V\u1edbi Office 2007, t\u01b0\u01a1ng \u1ee9ng l\u00e0: [$-101042A].<\/li>\n<li>Office 2010 \u2013 2013, t\u01b0\u01a1ng \u1ee9ng l\u00e0: [$-vi-VN]<\/li>\n<li>V\u00e0 Office 2016\/Office 365, b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft g\u1ecdn: [$-vi].<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/custom-format-ngay-tieng-viet.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24041\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-format-ngay-tieng-viet.jpg\" width=\"1063\" height=\"461\" title=\"custom-format-ngay-tieng-viet\"><\/a><\/li>\n<\/ul>\n<\/li>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"Cach_de_viet_cum_tu_%E2%80%9CNgay%E2%80%9D_%E2%80%9Cthang%E2%80%9D_%E2%80%9Cnam%E2%80%9D_trong_Custom_Format\"><\/span>C\u00e1ch \u0111\u1ec3 vi\u1ebft c\u1ee5m t\u1eeb \u201cNg\u00e0y\u201d, \u201cth\u00e1ng\u201d, \u201cn\u0103m\u201d trong Custom Format.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>V\u00e0 \u0111\u1ec3 ch\u00e8n th\u00eam ch\u1eef trong Custom Format b\u1ea1n d\u00f9ng d\u1ea5u nh\u00e1y k\u00e9p gi\u1eefa c\u00e1c \u201cch\u1eef\u201d, v\u00ed d\u1ee5 ta c\u00f3: dddd, \u201cng\u00e0y\u201d dd \u201cth\u00e1ng\u201d mm \u201cn\u0103m\u201d yyyy.<\/li>\n<li>Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 ch\u00e8n th\u00eam \u0111\u1ecba danh: \u201cH\u00e0 N\u1ed9i, ng\u00e0y\u201d dd \u201cth\u00e1ng\u201d mm \u201cn\u0103m\u201d yyyy. V\u00ed d\u1ee5, v\u1edbi ng\u00e0y 08\/03\/2017, ta c\u00f3: H\u00e0 N\u1ed9i, ng\u00e0y 08 th\u00e1ng 03 n\u0103m 2017.<\/li>\n<li>N\u1ebfu d\u00f9ng v\u1edbi h\u00e0m TEXT, b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft k\u00e8m d\u1ea5u \u201c\u201d ho\u1eb7c vi\u1ebft 2 c\u1eb7p d\u1ea5u \u201c\u201d nh\u01b0 v\u00ed d\u1ee5 b\u00ean d\u01b0\u1edbi \u0111\u00e2y:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/custom-format-text-convert-date.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24051\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-format-text-convert-date.jpg\" width=\"810\" height=\"268\" title=\"custom-format-text-convert-date\"><\/a><\/li>\n<\/ul>\n<\/li>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"Cach_hien_thi_so_Chung_minh_nhan_dan_9_so_va_Can_cuoc_cong_dan_12_so_trong_Excel\"><\/span>C\u00e1ch hi\u1ec3n th\u1ecb s\u1ed1 Ch\u1ee9ng minh nh\u00e2n d\u00e2n (9 s\u1ed1) v\u00e0 C\u0103n c\u01b0\u1edbc c\u00f4ng d\u00e2n (12 s\u1ed1) trong Excel.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>B\u1ea1n c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh hi\u1ec3n th\u1ecb c\u00e1c s\u1ed1 CMND, C\u0103n c\u01b0\u1edbc c\u00f4ng d\u00e2n v\u1edbi Custom Format \u0111\u1ec3 d\u1ec5 nh\u00ecn nh\u1ea5t.\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/custom-format-cancuoccongdan-cmnd.jpg\"><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24045\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-format-cancuoccongdan-cmnd.jpg\" width=\"521\" height=\"230\" title=\"custom-format-cancuoccongdan-cmnd\"><\/a><\/li>\n<\/ul>\n<\/li>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_tuoi_trong_Excel\"><\/span><strong>C\u00f4ng th\u1ee9c t\u00ednh tu\u1ed5i trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/li>\n<\/ul>\n<p>Ch\u00fang ta c\u00f3 h\u00e0m DATEDIF \u0111\u1ec3 t\u00ednh ra s\u1ed1 ng\u00e0y, th\u00e1ng, n\u0103m gi\u1eefa hai ng\u00e0y cho tr\u01b0\u1edbc. C\u00f4ng th\u1ee9c n\u00e0y c\u00f3 trong Microsoft Excel, tuy nhi\u00ean kh\u00f4ng \u0111\u01b0\u1ee3c g\u1ee3i \u00fd nh\u01b0 bao h\u00e0m kh\u00e1c. B\u1ea1n ch\u1ec9 vi\u1ec7c g\u00f5 \u0111\u00fang c\u00f4ng th\u1ee9c s\u1ebd v\u1eadn d\u1ee5ng \u0111\u01b0\u1ee3c.<\/p>\n<p>=DATEDIF(Ng\u00e0y sinh, Ng\u00e0y hi\u1ec7n t\u1ea1i, \u201cY\u201d)*10000 + DATEDIF(Ng\u00e0y sinh, Ng\u00e0y hi\u1ec7n t\u1ea1i, \u201cYM\u201d)*100+DATEDIF(Ng\u00e0y sinh, Ng\u00e0y hi\u1ec7n t\u1ea1i, \u201cMD\u201d)<\/p>\n<p>V\u00ed d\u1ee5 ta c\u00f3, ng\u00e0y sinh l\u00e0: 24\/01\/1987, v\u00e0 ng\u00e0y hi\u1ec7n t\u1ea1i l\u00e0: 28\/02\/2020, ta c\u00f3 k\u1ebft qu\u1ea3: 330104.<\/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-365.gif\" title=\"ex101_92019-nho-365\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>L\u00fac n\u00e0y \u00e1p d\u1ee5ng Custom Format ta s\u1ebd c\u00f3: 33 <strong>tu\u1ed5i<\/strong> 01 <strong>th\u00e1ng<\/strong> 04 <strong>ng\u00e0y<\/strong>.<\/p>\n<p>=TEXT(DATEDIF(\u201c1987\/01\/24\u201d, \u201c2020\/02\/28\u2033,\u201dY\u201d)*10000+DATEDIF(\u201c1987\/01\/24\u201d, \u201c2020\/02\/28\u2033,\u201dYM\u201d)*100+DATEDIF(\u201c1987\/01\/24\u201d, \u201c2020\/02\/28\u2033,\u201dMD\u201d),\u201d00 tu\u1ed5i 00 th\u00e1ng 00 ng\u00e0y\u201d)<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/cong-thuc-tinh-tuoi-trong-Excel-voi-Custom-Format.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-31588\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-tinh-tuoi-trong-excel-voi-custom-format.png\" width=\"1341\" height=\"523\" title=\"cong-thuc-tinh-tuoi-trong-excel-voi-custom-format\"><\/a><\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 ta s\u1ebd c\u00f3 c\u00e1ch hi\u1ec3n th\u1ecb cho ti\u1ebfng Anh khi v\u1eadn d\u1ee5ng v\u1edbi h\u00e0m TEXT khi ph\u00e2n bi\u1ec7t s\u1ed1 nhi\u1ec1u v\u00e0 s\u1ed1 \u00edt.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/cong-thuc-tinh-tuoi-trong-Excel-bang-tieng-anh.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-31598\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-tinh-tuoi-trong-excel-bang-tieng-anh.png\" width=\"787\" height=\"307\" title=\"cong-thuc-tinh-tuoi-trong-excel-bang-tieng-anh\"><\/a><\/p>\n<ul>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"Cach_hien_thi_so_0_o_so_dien_thoai_10_%E2%80%93_11_so_trong_Excel\"><\/span>C\u00e1ch hi\u1ec3n th\u1ecb s\u1ed1 0 \u1edf s\u1ed1 \u0111i\u1ec7n tho\u1ea1i 10 \u2013 11 s\u1ed1 trong Excel.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/custom-format-sodienthoai.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-24046 size-full aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-format-sodienthoai.jpg\" width=\"281\" height=\"65\" title=\"custom-format-sodienthoai\"><\/a><\/p>\n<p>Ngo\u00e0i v\u00ed d\u1ee5 \u0111\u1ea7u ti\u00ean v\u1ec1 c\u00fa ph\u00e1p m\u00ecnh c\u00f3 vi\u1ebft v\u00ed d\u1ee5 v\u1ec1 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i gi\u1eefa 10 s\u1ed1 v\u00e0 11 s\u1ed1. Tuy nhi\u00ean b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00e1ch g\u1ecdn h\u01a1n v\u1edbi: 0#00 000 0000. V\u1edbi d\u1ea5u # \u0111\u1ea1i di\u1ec7n cho s\u1ed1 c\u00f3 th\u1ec3 c\u00f3 ho\u1eb7c kh\u00f4ng c\u00f3, nh\u01b0 v\u1eady v\u1edbi tr\u01b0\u1eddng h\u1ee3p 10 s\u1ed1, th\u00ec kh\u00f4ng c\u1ea7n thi\u1ebft ph\u1ea3i th\u00eam s\u1ed1 \u1edf sau s\u1ed1 0 \u0111\u1ea7u ti\u00ean. V\u00e0 v\u1edbi 11 s\u1ed1, th\u00ec s\u1ebd hi\u1ec3n th\u1ecb r\u00f5 ra. Nh\u01b0ng chuy\u1ec7n \u0111\u00f3 c\u0169ng x\u01b0a c\u0169 r\u1ed3i, v\u00ec B\u1ed9 \u201cT\u01b0 T\u00ea (4T)\u201d \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i t\u1ea5t c\u1ea3 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u1ec1 10 s\u1ed1 r\u1ed3i.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ket_hop_giua_ham_TEXT_va_CUSTOM_FORMAT\"><\/span>K\u1ebft h\u1ee3p gi\u1eefa h\u00e0m TEXT v\u00e0 CUSTOM FORMAT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nh\u01b0 \u0111\u00e3 n\u00f3i t\u1eeb \u0111\u1ea7u, vi\u1ec7c \u00e1p d\u1ee5ng CUSTOM FORMAT kh\u00f4ng l\u00e0m thay \u0111\u1ed5i b\u1ea3n ch\u1ea5t d\u1eef li\u1ec7u. V\u00ec v\u1eady, d\u1eef li\u1ec7u s\u1ebd l\u01b0u d\u1ea1ng s\u1ed1, v\u00e0 b\u1ea1n s\u1ebd d\u1ec5 nh\u00ecn h\u01a1n th\u00f4i. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i sang h\u1eb3n d\u1ea1ng TEXT theo \u0111\u1ecbnh d\u1ea1ng tr\u00ean. R\u1ea5t may, Excel c\u00f3 h\u1eb3n h\u00e0m TEXT \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i v\u1edbi \u00e1p d\u1ee5ng theo c\u00fa ph\u00e1p Custom Format t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<p>V\u00ed d\u1ee5, b\u1ea1n c\u00f3 d\u1eef li\u1ec7u ng\u00e0y: 05\/02\/2019, b\u1ea1n mu\u1ed1n ghi nh\u1eadn d\u1ea1ng TEXT v\u00ec l\u00fd do n\u00e0o \u0111\u00f3. B\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft\u00a0c\u00f4ng th\u1ee9c nh\u01b0 sau:\u00a0=TEXT(DATE(2019,05,02), \u201cdd\/mm\/yyyy\u201d). V\u00ec sao l\u1ea1i d\u00f9ng h\u00e0m DATE(N\u0103m, Th\u00e1ng, Ng\u00e0y) m\u00e0 kh\u00f4ng d\u00f9ng ch\u1eef, ho\u1eb7c tham chi\u1ebfu \u00f4? \u0110\u01a1n gi\u1ea3n m\u00ecnh s\u1ee3 c\u00e1c b\u1ea1n l\u00e0m sai! H\u00e3y d\u00f9ng h\u00e0m DATE khi tham chi\u1ebfu \u0111\u1ebfn ng\u00e0y, n\u1ebfu b\u1ea1n kh\u00f4ng ch\u1eafc ch\u1eafn vi\u1ec7c nh\u1eadp ng\u00e0y th\u00e1ng n\u0103m \u0111\u00fang chu\u1ea9n thi\u1ebft l\u1eadp trong REGION.<\/p>\n<p>\u0110\u1ec3 tr\u00e1nh sai v\u1ec1 ng\u00e0y b\u1ea1n nh\u1edb 2 c\u00e1ch nh\u1eadp sau s\u1ebd tr\u00e1nh sai s\u00f3t.<\/p>\n<ul>\n<li>D\u00f9ng h\u00e0m DATE(N\u0103m, Th\u00e1ng, Ng\u00e0y), v\u00ed d\u1ee5: Date(2018,12,31)<\/li>\n<li>Nh\u1eadp ng\u00e0y theo nguy\u00ean t\u1eafc yyyy\/mm\/dd, v\u00ed d\u1ee5: 2018\/12\/31<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/custom-format-text.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24049 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-format-text.jpg\" width=\"638\" height=\"153\" title=\"custom-format-text\"><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ket_hop_CUSTOM_FORMAT_voi_CONDITIONAL_FORMATTING\"><\/span><strong>K\u1ebft h\u1ee3p CUSTOM FORMAT v\u1edbi CONDITIONAL FORMATTING.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ngo\u00e0i Fill trong Conditional Formatting \u0111\u1ec3 t\u00f4 m\u00e0u n\u1ec1n, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng Custom Format \u0111\u1ec3 hi\u1ec3n th\u1ecb ra k\u1ebft qu\u1ea3 mong mu\u1ed1n c\u1ee7a m\u00ecnh khi \u0111i\u1ec1u ki\u1ec7n \u0111\u1ecbnh d\u1ea1ng th\u1ecfa.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/custom-format-trong-conditional-formatting.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24057\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-format-trong-conditional-formatting.jpg\" width=\"1002\" height=\"387\" title=\"custom-format-trong-conditional-formatting\"><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_co_duoc_cac_ky_tu_dac_biet_nhu_%E2%96%B2%E2%96%BC_trong_Custom_Format\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t nh\u01b0: \u25b2\u25bc trong Custom Format?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p t\u1eeb b\u00ean ngo\u00e0i, v\u00ed d\u1ee5 t\u1eeb c\u00e1c k\u00fd t\u1ef1 b\u00ean tr\u00ean, ho\u1eb7c v\u00e0o Insert =&gt; Ch\u1ecdn Symbol, sau \u0111\u00f3 ch\u1ecdn Arial, v\u00e0 ch\u1ecdn Subnet:\u00a0Geometric Shape. V\u00e0 ch\u1ecdn k\u00fd t\u1ef1 t\u01b0\u01a1ng \u1ee9ng \u0111\u1ec3 ch\u00e8n v\u00e0o \u00f4, sau \u0111\u00f3 copy ra l\u00e0 \u0111\u01b0\u1ee3c.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ap_dung_CUSTOM_FORMAT_cho_FIELD_CODE_trong_Mail_Merge\"><\/span>\u00c1p d\u1ee5ng CUSTOM FORMAT cho FIELD CODE trong Mail Merge.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong Word b\u1ea1n c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh cho \u0111\u1ecbnh d\u1ea1ng Ng\u00e0y v\u00e0 s\u1ed1 trong Mail Merge. T\u01b0\u01a1ng \u1ee9ng tu\u1ea7n t\u1ef1 nh\u01b0 sau:<\/p>\n<ul>\n<li>Ng\u00e0y: @.\n<ul>\n<li>V\u00ed d\u1ee5:\u00a0{MERGEFIELD NgayCap @ yyyyMMdd}<\/li>\n<li>C\u00e1ch th\u1ec3 hi\u1ec7n ch\u1eef \u201cng\u00e0y th\u00e1ng n\u0103m\u201d trong Word, ta d\u00f9ng d\u1ea5u nh\u00e1y \u0111\u01a1n cho ch\u1eef mu\u1ed1n th\u00eam v\u00e0o: {MERGEFIELD NgayCap @ \u201d \u2018ng\u00e0y\u2019 dd \u2018th\u00e1ng\u2019 MM \u2018n\u0103m\u2019 yyyy\u201d}<\/li>\n<\/ul>\n<\/li>\n<li>S\u1ed1: #. V\u00ed d\u1ee5:\u00a0{MERGEFIELD TrongLuong # #,##0.00kg}<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/custom-format-mergefield-format.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24059\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-format-mergefield-format.jpg\" width=\"815\" height=\"184\" title=\"custom-format-mergefield-format\"><\/a><\/p>\n<p>V\u00ed d\u1ee5 minh h\u1ecda:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/mailmerge-dinh-dang-ngay-thang-nam-trong-word.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-31386\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/mailmerge-dinh-dang-ngay-thang-nam-trong-word.jpg\" width=\"1091\" height=\"146\" title=\"mailmerge-dinh-dang-ngay-thang-nam-trong-word\"><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dinh_dang_to_mau_sac_trong_CUSTOM_FORMAT\"><\/span><strong>\u0110\u1ecbnh d\u1ea1ng t\u00f4 m\u00e0u s\u1eafc trong CUSTOM FORMAT<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng b\u1ea3ng m\u00e0u trong Custom Format, m\u00e3 m\u00e0u [Color1] \u2013 [Color56], b\u1ea3ng m\u00e0u s\u1eafc t\u01b0\u01a1ng \u1ee9ng b\u00ean d\u01b0\u1edbi.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/custom-format-color-list.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24058\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-format-color-list.jpg\" width=\"723\" height=\"281\" title=\"custom-format-color-list\"><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cac_phim_tat_thong_dung_dung_de_dinh_dang_trong_Excel\"><\/span>C\u00e1c ph\u00edm t\u1eaft th\u00f4ng d\u1ee5ng d\u00f9ng \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/Custom-Format-Phimtat-shortcut.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-24089\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-format-phimtat-shortcut.jpg\" width=\"462\" height=\"363\" title=\"custom-format-phimtat-shortcut\"><\/a><\/p>\n<p>N\u1ebfu n\u1ed9i dung tr\u00ean v\u1eabn ch\u01b0a \u0111\u00e1p \u1ee9ng t\u00ecm ki\u1ebfm c\u1ee7a b\u1ea1n. B\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng ch\u1ee9c n\u0103ng t\u00ecm ki\u1ebfm tr\u00ean trang web n\u00e0y, v\u1edbi t\u1eeb kh\u00f3a: Custom Format, b\u1ea1n nh\u00e9! V\u00e0 c\u00e1c b\u00e0i hay kh\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o:<\/p>\n<ul>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-du-lieu-su-dung-custom-format.html\" target=\"_blank\" rel=\"noopener noreferrer\">\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u s\u1eed d\u1ee5ng Custom Format<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-custom-trong-excel-custom-format-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">\u0110\u1ecbnh d\u1ea1ng custom trong Excel \u2013 Custom format trong Excel<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-tien-trong-excel-voi-custom-formats.html\" target=\"_blank\" rel=\"noopener noreferrer\">\u0110\u1ecbnh d\u1ea1ng s\u1ed1 ti\u1ec1n trong Excel v\u1edbi Custom Formats<\/a><\/li>\n<\/ul>\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-365.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4506,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4505","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\/4505","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=4505"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4505\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4506"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4505"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}