{"id":8426,"date":"2024-12-22T14:32:21","date_gmt":"2024-12-22T14:32:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-chi-tiet-custom-number-format-trong-excel\/"},"modified":"2024-12-22T14:32:21","modified_gmt":"2024-12-22T14:32:21","slug":"huong-dan-chi-tiet-custom-number-format-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-chi-tiet-custom-number-format-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft custom number format trong Excel"},"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-676822f42f44a\" 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-number-format-trong-excel.html#Dinh_dang_Custom_format_trong_Excel\" title=\"\u0110\u1ecbnh d\u1ea1ng Custom format trong Excel\">\u0110\u1ecbnh d\u1ea1ng Custom format trong Excel<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/custom-number-format-trong-excel.html#Custom_Number_Format_la_gi\" title=\"Custom Number Format l\u00e0 g\u00ec?\">Custom Number Format l\u00e0 g\u00ec?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/custom-number-format-trong-excel.html#Lam_the_nao_de_ap_dung_Custom_number_format\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u00e1p d\u1ee5ng Custom number format\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u00e1p d\u1ee5ng Custom number format<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/custom-number-format-trong-excel.html#Tai_sao_lai_su_dung_Custom_number_format\" title=\"T\u1ea1i sao l\u1ea1i s\u1eed d\u1ee5ng Custom number format\">T\u1ea1i sao l\u1ea1i s\u1eed d\u1ee5ng Custom number format<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/custom-number-format-trong-excel.html#Custom_number_format_%E2%80%93_tuy_chinh_dinh_dang_cho_du_lieu_cua_ban\" title=\"Custom number format \u2013 t\u00f9y ch\u1ec9nh \u0111\u1ecbnh d\u1ea1ng cho d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n\">Custom number format \u2013 t\u00f9y ch\u1ec9nh \u0111\u1ecbnh d\u1ea1ng cho d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n<\/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\/custom-number-format-trong-excel.html#Cau_truc_format\" title=\"C\u1ea5u tr\u00fac format\">C\u1ea5u tr\u00fac 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-number-format-trong-excel.html#Khong_phai_tat_ca_deu_bat_buoc\" title=\"Kh\u00f4ng ph\u1ea3i t\u1ea5t c\u1ea3 \u0111\u1ec1u b\u1eaft bu\u1ed9c\">Kh\u00f4ng ph\u1ea3i t\u1ea5t c\u1ea3 \u0111\u1ec1u b\u1eaft bu\u1ed9c<\/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-number-format-trong-excel.html#Ki_tu_hien_thi_truc_tiep\" title=\"K\u00ed t\u1ef1 hi\u1ec3n th\u1ecb tr\u1ef1c ti\u1ebfp\">K\u00ed t\u1ef1 hi\u1ec3n th\u1ecb tr\u1ef1c ti\u1ebfp<\/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-number-format-trong-excel.html#Ki_tu_thoat\" title=\"K\u00ed t\u1ef1 tho\u00e1t\">K\u00ed t\u1ef1 tho\u00e1t<\/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-10\" href=\"https:\/\/blog.hocexcel.online\/custom-number-format-trong-excel.html#Placeholders_dai_dien\" title=\"Placeholders (\u0111\u1ea1i di\u1ec7n)\">Placeholders (\u0111\u1ea1i di\u1ec7n)<\/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\/custom-number-format-trong-excel.html#Lam_tron_tu_dong\" title=\"L\u00e0m tr\u00f2n t\u1ef1 \u0111\u1ed9ng\">L\u00e0m tr\u00f2n t\u1ef1 \u0111\u1ed9ng<\/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-number-format-trong-excel.html#Custom_number_format_cho_text\" title=\"Custom number format cho text\">Custom number format cho text<\/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-number-format-trong-excel.html#Dinh_dang_cho_du_lieu_ngay_thang\" title=\"\u0110\u1ecbnh d\u1ea1ng cho d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng\">\u0110\u1ecbnh d\u1ea1ng cho d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng<\/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-number-format-trong-excel.html#Dinh_dang_du_lieu_thoi_gian\" title=\"\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u th\u1eddi gian\">\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u th\u1eddi gian<\/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-number-format-trong-excel.html#Dinh_dang_cho_thoi_gian_troi_qua\" title=\"\u0110\u1ecbnh d\u1ea1ng cho th\u1eddi gian tr\u00f4i qua\">\u0110\u1ecbnh d\u1ea1ng cho th\u1eddi gian tr\u00f4i qua<\/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-number-format-trong-excel.html#Dinh_dang_mau_sac\" title=\"\u0110\u1ecbnh d\u1ea1ng m\u00e0u s\u1eafc\">\u0110\u1ecbnh d\u1ea1ng m\u00e0u s\u1eafc<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/custom-number-format-trong-excel.html#Custom_number_format_thay_the_Conditional_Formatting\" title=\"Custom number format thay th\u1ebf Conditional Formatting\">Custom number format thay th\u1ebf Conditional Formatting<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Dinh_dang_Custom_format_trong_Excel\"><\/span>\u0110\u1ecbnh d\u1ea1ng Custom format trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Custom_Number_Format_la_gi\"><\/span>Custom Number Format l\u00e0 g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Custom number format l\u00e0 m\u1ed9t t\u00ednh n\u0103ng \u0111\u1ecbnh d\u1ea1ng cho ph\u00e9p b\u1ea1n t\u1ea1o ra nh\u1eefng ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng ri\u00eang.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_ap_dung_Custom_number_format\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u00e1p d\u1ee5ng Custom number format<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Custom format, b\u1ea1n c\u1ea7n ph\u1ea3i bi\u1ebft v\u1ecb tr\u00ed c\u1ee7a n\u00f3 \u0111\u00e3. \u0110\u1ea7u ti\u00ean, \u1ea5n ph\u00edm t\u1eaft<strong> Ctrl + 1\u00a0<\/strong>\u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i\u00a0Format Cells.<\/p>\n<p>Sau \u0111\u00f3, trong m\u1ee5c\u00a0<strong>Number<\/strong>, b\u1ea1n s\u1ebd th\u1ea5y\u00a0<strong>Custom<\/strong> trong danh s\u00e1ch Category b\u00ean tr\u00e1i:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27893\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-number-format-1.png\" width=\"540\" height=\"470\" title=\"custom-number-format-1\"><\/p>\n<p>C\u00f3 r\u1ea5t nhi\u1ec1u th\u00f4ng tin m\u1edbi l\u1ea1 t\u1ea1i \u0111\u00e2y ph\u1ea3i kh\u00f4ng? \u0110\u1eebng lo l\u1eafng, b\u1edfi ch\u00fang \u0111\u1ec1u ch\u1ec9 t\u1edbi nh\u1eefng ph\u01b0\u01a1ng th\u1ee9c c\u1ee5 th\u1ec3 b\u1ea1n s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u trong Excel. Sau b\u00e0i vi\u1ebft n\u00e0y, c\u00e1c b\u1ea1n s\u1ebd hi\u1ec3u \u00fd ngh\u0129a c\u1ee7a nh\u1eefng k\u00ed t\u1ef1 tr\u00ean v\u00e0 \u0111\u1ed3ng th\u1eddi c\u00f3 th\u1ec3 t\u1ef1 t\u1ea1o ra m\u1ed9t \u0111\u1ecbnh d\u1ea1ng cho ri\u00eang m\u00ecnh.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Tai_sao_lai_su_dung_Custom_number_format\"><\/span>T\u1ea1i sao l\u1ea1i s\u1eed d\u1ee5ng Custom number format<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Tr\u01b0\u1edbc khi \u0111i s\u00e2u v\u00e0o chi ti\u1ebft v\u1edbi c\u00e1c v\u00ed d\u1ee5, h\u00e3y gi\u1ea3i th\u00edch t\u1ea1i sao l\u1ea1i s\u1eed d\u1ee5ng Custom number format \u0111\u00e3:<\/p>\n<p>L\u1ee3i \u00edch l\u1edbn nh\u1ea5t \u1edf \u0111\u00e2y \u0111\u00f3 l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i c\u00e1ch hi\u1ec3n th\u1ecb h\u00ecnh th\u1ee9c c\u1ee7a d\u1eef li\u1ec7u nh\u01b0ng kh\u00f4ng l\u00e0m thay \u0111\u1ed5i n\u1ed9i dung d\u1eef li\u1ec7u \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-772.gif\" title=\"ex101_92019-nho-772\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>B\u00e2y gi\u1edd, h\u00e3y b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u Custom number format.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Custom_number_format_%E2%80%93_tuy_chinh_dinh_dang_cho_du_lieu_cua_ban\"><\/span>Custom number format \u2013 t\u00f9y ch\u1ec9nh \u0111\u1ecbnh d\u1ea1ng cho d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Cau_truc_format\"><\/span>C\u1ea5u tr\u00fac format<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Custom number format c\u00f3 c\u1ea5u tr\u00fac c\u1ee5 th\u1ec3 c\u1ee7a n\u00f3, chia th\u00e0nh t\u1ed1i \u0111a 4 v\u00f9ng ph\u00e2n c\u00e1ch b\u1edfi d\u1ea5u ch\u1ea5m ph\u1ea9y. C\u1ea5u tr\u00fac n\u00e0y nh\u00ecn t\u1eeb ngo\u00e0i v\u00e0o kh\u00e1 ph\u1ee9c t\u1ea1p, tuy nhi\u00ean b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 ghi nh\u1edb nh\u01b0 sau:<\/p>\n<ol>\n<li>V\u00f9ng gi\u00e1 tr\u1ecb d\u01b0\u01a1ng<\/li>\n<li>V\u00f9ng gi\u00e1 tr\u1ecb \u00e2m<\/li>\n<li>V\u00f9ng gi\u00e1 tr\u1ecb b\u1eb1ng 0<\/li>\n<li>V\u00f9ng gi\u00e1 tr\u1ecb text<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27897\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-number-format-2.png\" width=\"515\" height=\"156\" title=\"custom-number-format-2\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Khong_phai_tat_ca_deu_bat_buoc\"><\/span>Kh\u00f4ng ph\u1ea3i t\u1ea5t c\u1ea3 \u0111\u1ec1u b\u1eaft bu\u1ed9c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>D\u00f9 cho m\u1ed9t number format c\u00f3 th\u1ec3 bao g\u1ed3m t\u1edbi 4 v\u00f9ng, th\u00ec ta ch\u1ec9 c\u1ea7n c\u00f3 t\u1ed1i thi\u1ec3u 1 v\u00f9ng. Theo m\u1eb7c \u0111\u1ecbnh, v\u00f9ng \u0111\u1ea7u ti\u00ean s\u1ebd \u00e1p d\u1ee5ng cho s\u1ed1 d\u01b0\u01a1ng, v\u00f9ng th\u1ee9 hai cho s\u1ed1 \u00e2m, v\u00f9ng th\u1ee9 ba cho gi\u00e1 tr\u1ecb 0 v\u00e0 v\u00f9ng th\u1ee9 t\u01b0 cho text.<\/p>\n<p>\u00a0<\/p>\n<p>C\u1ea5u tr\u00fac b\u1ecb \u1ea3nh h\u01b0\u1edfng \u0111\u01b0\u1ee3c bi\u1ec3u th\u1ecb nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27899\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-number-format-3.png\" width=\"481\" height=\"211\" title=\"custom-number-format-3\"><\/p>\n<p>Nh\u00ecn v\u00e0o b\u1ea3ng tr\u00ean ta c\u00f3 th\u1ec3 hi\u1ec3u nh\u01b0 sau:<\/p>\n<p>N\u1ebfu ta ch\u1ec9 \u0111\u1ecbnh d\u1ea1ng 1 v\u00f9ng, \u0111\u1ecbnh d\u1ea1ng \u0111\u00f3 s\u1ebd \u1ea3nh h\u01b0\u1edfng t\u1ea5t c\u1ea3.<\/p>\n<p>N\u1ebfu b\u1ea1n t\u1ea1o ra m\u1ed9t format v\u1edbi hai v\u00f9ng, v\u00f9ng \u0111\u1ea7u ti\u00ean s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ed3ng th\u1eddi cho s\u1ed1 d\u01b0\u01a1ng, s\u1ed1 0 v\u00e0 text, v\u00f9ng th\u1ee9 hai s\u1eed d\u1ee5ng cho s\u1ed1 \u00e2m.<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p c\u00f3 3 v\u00f9ng, v\u00f9ng \u0111\u1ea7u ti\u00ean thu l\u1ea1i ch\u1ec9 s\u1eed d\u1ee5ng cho s\u1ed1 d\u01b0\u01a1ng v\u00e0 text.<\/p>\n<p>Khi \u0111\u1ee7 4 v\u00f9ng, m\u1ed7i \u0111\u1ecbnh d\u1ea1ng trong 1 v\u00f9ng bi\u1ec3u th\u1ecb cho m\u1ed9t lo\u1ea1i d\u1eef li\u1ec7u.<\/p>\n<p>\u0110\u1ec3 b\u1ecf qua v\u00f9ng, ta s\u1eed d\u1ee5ng d\u1ea5u ch\u1ea5m ph\u1ea9y m\u00e0 kh\u00f4ng \u0111\u1ecbnh d\u1ea1ng g\u00ec trong v\u00f9ng \u0111\u00f3 c\u1ea3, ho\u1eb7c s\u1eed d\u1ee5ng General nh\u01b0 sau:<\/p>\n<blockquote>\n<p><em>\u0110\u1ecbnh d\u1ea1ng v\u00f9ng 1; General; General; \u0110\u1ecbnh d\u1ea1ng v\u00f9ng 4<\/em><\/p>\n<\/blockquote>\n<h4><span class=\"ez-toc-section\" id=\"Ki_tu_hien_thi_truc_tiep\"><\/span>K\u00ed t\u1ef1 hi\u1ec3n th\u1ecb tr\u1ef1c ti\u1ebfp<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Trong Custom Format, c\u00f3 nh\u1eefng k\u00ed t\u1ef1 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb tr\u1ef1c ti\u1ebfp, trong khi nh\u1eefng k\u00ed t\u1ef1 kh\u00e1c c\u1ea7n ph\u1ea3i qua x\u1eed l\u00fd. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 danh s\u00e1ch nh\u1eefng k\u00ed t\u1ef1 hi\u1ec3n th\u1ecb tr\u1ef1c ti\u1ebfp:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27918\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-number-format-4.png\" width=\"450\" height=\"355\" title=\"custom-number-format-4\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Ki_tu_thoat\"><\/span>K\u00ed t\u1ef1 tho\u00e1t<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>K\u00ed t\u1ef1 tho\u00e1t l\u00e0 nh\u1eefng k\u00ed t\u1ef1 kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng tr\u1ef1c ti\u1ebfp trong custom number format. Ch\u00fang ch\u1ec9 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi \u0111\u01b0\u1ee3c \u201ctho\u00e1t\u201d b\u1edfi k\u00ed t\u1ef1 \u0111i k\u00e8m. V\u00ed d\u1ee5: d\u1ea5u sao (*), d\u1ea5u th\u0103ng (#), ph\u1ea7n tr\u0103m (%) s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb tr\u1ef1c ti\u1ebfp. Ch\u1ec9 khi \u0111i k\u00e8m d\u1ea5u g\u1ea1ch ch\u00e9o (), b\u1ea1n m\u1edbi c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng trong custom number format tr\u1ef1c ti\u1ebfp:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27920\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-number-format-5.png\" width=\"280\" height=\"103\" title=\"custom-number-format-5\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Placeholders_dai_dien\"><\/span>Placeholders (\u0111\u1ea1i di\u1ec7n)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t s\u1ed1 k\u00fd t\u1ef1 c\u00f3 \u00fd ngh\u0129a nh\u1ea5t \u0111\u1ecbnh trong custom number format, ch\u1eb3ng h\u1ea1n:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27940\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-number-format-6.png\" width=\"441\" height=\"208\" title=\"custom-number-format-6\"><\/p>\n<p>C\u1ee5 th\u1ec3:<\/p>\n<p><strong>S\u1ed1 0 (0)<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 hi\u1ec3n th\u1ecb nh\u1eefng s\u1ed1 0 khi gi\u00e1 tr\u1ecb s\u1ed1 c\u00f3 \u00edt ch\u1eef s\u1ed1 h\u01a1n \u0111\u1ecbnh d\u1ea1ng.\u00a0 Ch\u1eb3ng h\u1ea1n nh\u01b0 \u0111\u1ecbnh d\u1ea1ng <em>00000.00000<\/em> s\u1ebd hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb<strong> 19.58<\/strong> th\u00e0nh <em>00019.58000.<\/em><\/p>\n<p><strong>D\u1ea5u th\u0103ng (#)<\/strong> ch\u1ec9 hi\u1ec3n th\u1ecb nh\u1eefng ch\u1eef s\u1ed1 c\u1ea7n thi\u1ebft, c\u00f2n l\u1ea1i b\u1ecf qua. N\u00f3i c\u00e1ch kh\u00e1c, n\u1ebfu ta \u0111\u1ecbnh d\u1ea1ng <em>#.#\u00a0<\/em>s\u1ebd l\u00e0m tr\u00f2n\u00a0<strong>19.58<\/strong> th\u00e0nh\u00a0<em>19.6<\/em>.<\/p>\n<p><strong>D\u1ea5u h\u1ecfi (?)<\/strong> s\u1eed d\u1ee5ng \u0111\u1ec3 d\u00f3ng h\u00e0ng. C\u1ee5 th\u1ec3 nh\u01b0 \u1ea3nh sau:<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27944\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-number-format-7.png\" width=\"672\" height=\"556\" title=\"custom-number-format-7\"><\/p>\n<p><strong>D\u1ea5u ch\u1ea5m (.)<\/strong> \u0111\u1ea1i di\u1ec7n cho ph\u1ea7n ng\u0103n c\u00e1ch th\u1eadp ph\u00e2n trong gi\u00e1 tr\u1ecb s\u1ed1.<\/p>\n<p><strong>D\u1ea5u ph\u1ea9y (,)<\/strong> \u0111\u1ea1i di\u1ec7n cho ng\u0103n c\u00e1ch ph\u1ea7n ngh\u00ecn.<\/p>\n<p><strong>D\u1ea5u sao (*)<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1eb7p l\u1ea1i k\u00ed t\u1ef1 cho t\u1edbi khi \u0111\u1ea1t \u0111\u1ee7 \u0111\u1ed9 r\u1ed9ng c\u1ed9t.<\/p>\n<p><strong>G\u1ea1ch d\u01b0\u1edbi (_)\u00a0<\/strong>s\u1eed d\u1ee5ng khi ta mu\u1ed1n th\u00eam kho\u1ea3ng tr\u1eafng trong \u0111\u1ecbnh d\u1ea1ng.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lam_tron_tu_dong\"><\/span>L\u00e0m tr\u00f2n t\u1ef1 \u0111\u1ed9ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng l\u00e0m tr\u00f2n c\u00e1c gi\u00e1 tr\u1ecb m\u1ed7i khi \u0111\u1ecbnh d\u1ea1ng. Tuy nhi\u00ean \u0111\u00e2y ch\u1ec9 l\u00e0 l\u00e0m tr\u00f2n h\u00ecnh th\u1ee9c, c\u00f2n gi\u00e1 tr\u1ecb th\u1ef1c v\u1eabn kh\u00f4ng \u0111\u1ed5i.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Custom_number_format_cho_text\"><\/span>Custom number format cho text<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 hi\u1ec3n th\u1ecb \u0111\u1ed3ng th\u1eddi c\u1ea3 ch\u1eef v\u00e0 s\u1ed1, ta \u0111\u1eb7t ch\u1eef v\u00e0o trong d\u1ea5u ngo\u1eb7c k\u00e9p (\u201c\u201d). B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111i\u1ec1u n\u00e0y \u0111\u1ec3 n\u1ed1i chu\u1ed7i v\u00e0o trong custom number format m\u00e0 kh\u00f4ng \u1ea3nh h\u01b0\u1edfng t\u1edbi ki\u1ec3u gi\u00e1 tr\u1ecb d\u1eef li\u1ec7u. V\u00ed d\u1ee5: \u0111\u1ecbnh d\u1ea1ng <em>General \u201cngh\u00ecn\u201d<\/em> s\u1ebd bi\u1ebfn gi\u00e1 tr\u1ecb\u00a0<strong>10<\/strong> th\u00e0nh\u00a0<em>10 ngh\u00ecn<\/em>.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dinh_dang_cho_du_lieu_ngay_thang\"><\/span>\u0110\u1ecbnh d\u1ea1ng cho d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ng\u00e0y th\u00e1ng trong Excel th\u1ef1c ra l\u00e0 nh\u1eefng con s\u1ed1, b\u1edfi v\u1eady b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng custom number format \u0111\u1ec3 thay \u0111\u1ed5i c\u00e1ch hi\u1ec3n th\u1ecb. Tham kh\u1ea3o m\u1ed9t s\u1ed1 \u0111\u1ecbnh d\u1ea1ng d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27947\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-number-format-8.png\" width=\"479\" height=\"255\" title=\"custom-number-format-8\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dinh_dang_du_lieu_thoi_gian\"><\/span>\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u th\u1eddi gian<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Th\u1eddi gian trong Excel l\u00e0 m\u1ed9t ph\u1ea7n c\u1ee7a ng\u00e0y, ch\u1eb3ng h\u1ea1n nh\u01b0 12 gi\u1edd tr\u01b0a l\u00e0 0.5, 6 gi\u1edd t\u1ed1i l\u00e0 0.75. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 \u0111\u1ecbnh d\u1ea1ng sau \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27948\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-number-format-9.png\" width=\"479\" height=\"163\" title=\"custom-number-format-9\"><\/p>\n<p><em>L\u01b0u \u00fd: \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ph\u00fat (m) kh\u00f4ng th\u1ec3 \u0111\u1ee9ng \u0111\u1ed9c l\u1eadp v\u00ec n\u00f3 xung \u0111\u1ed9t v\u1edbi \u0111\u1ecbnh d\u1ea1ng th\u00e1ng (m).<\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dinh_dang_cho_thoi_gian_troi_qua\"><\/span>\u0110\u1ecbnh d\u1ea1ng cho th\u1eddi gian tr\u00f4i qua<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Th\u1eddi gian tr\u00f4i qua l\u00e0 m\u1ed9t tr\u01b0\u1eddng h\u1ee3p \u0111\u1eb7c bi\u1ec7t c\u1ee7a th\u1eddi gian. \u0110\u1ec3 bi\u1ec3u th\u1ecb ta \u0111\u1eb7t d\u1eef li\u1ec7u trong d\u1ea5u ngo\u1eb7c vu\u00f4ng. Ch\u1eb3ng h\u1ea1n, \u0111\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c 3.25 ng\u00e0y t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi bao nhi\u00eau gi\u1edd, ph\u00fat, gi\u00e2y ta l\u00e0m nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27949\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-number-format-10.png\" width=\"479\" height=\"163\" title=\"custom-number-format-10\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dinh_dang_mau_sac\"><\/span>\u0110\u1ecbnh d\u1ea1ng m\u00e0u s\u1eafc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u00ean c\u1ea1nh Conditional Formatting v\u00e0 t\u00f4 m\u00e0u, Excel cho ph\u00e9p ta s\u1eed d\u1ee5ng custom number format cho vi\u1ec7c th\u00eam m\u00e0u v\u00e0o d\u1eef li\u1ec7u. \u0110\u1ec3 th\u00eam m\u00e0u, ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u00e3 \u0111\u1ecbnh d\u1ea1ng <em>[<strong>name<\/strong>] v\u1edbi name l\u00e0\u00a0<strong>t\u00ean m\u00e0u trong ti\u1ebfng anh<\/strong><\/em> ho\u1eb7c\u00a0<em>[Color<strong>X<\/strong>] v\u1edbi X l\u00e0\u00a0<strong>s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 56<\/strong>.<\/em><\/p>\n<p>V\u00ed d\u1ee5, [red] v\u00e0 [color3] s\u1ebd t\u00f4 m\u00e0u \u0111\u1ecf.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Custom_number_format_thay_the_Conditional_Formatting\"><\/span>Custom number format thay th\u1ebf Conditional Formatting<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Custom number format cho ph\u00e9p t\u1ed1i \u0111a 2 \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c vi\u1ebft trong d\u1ea5u ngo\u1eb7c vu\u00f4ng. V\u00ed d\u1ee5, \u0111\u1ec3 t\u00f4 m\u00e0u nh\u1eefng gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n 100, ta s\u1eed d\u1ee5ng: [red][&lt;100]. \u0110\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p nhi\u1ec1u h\u01a1n 2 \u0111i\u1ec1u ki\u1ec7n, b\u1ea1n c\u1ea7n chuy\u1ec3n sang conditional formatting.<\/p>\n<hr>\n<p>\u0110\u1ec3 t\u00ecm hi\u1ec3u s\u00e2u h\u01a1n v\u1ec1 Custom Format, b\u1ea1n h\u00e3y \u0111\u1ecdc c\u00e1c b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/custom-format-va-nhung-ap-dung-huu-ich.html\">Custom Format v\u00e0 nh\u1eefng \u00e1p d\u1ee5ng h\u1eefu \u00edch<\/a><\/strong><\/p>\n<p><b>C\u00e1ch <a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-du-lieu-trong-excel.html\">\u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel<\/a> \u0111\u01a1n gi\u1ea3n<\/b><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-tien-trong-excel-voi-custom-formats.html\">\u0110\u1ecbnh d\u1ea1ng s\u1ed1 ti\u1ec1n v\u1edbi Custom Format<\/a><\/strong><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-du-lieu-su-dung-custom-format.html\">\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u s\u1eed d\u1ee5ng Custom Format<\/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\/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-772.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8427,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8426","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\/8426","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=8426"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8426\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8427"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}