{"id":11429,"date":"2025-01-15T03:06:57","date_gmt":"2025-01-15T03:06:57","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-them-cac-so-0-vao-dau-cac-gia-tri-trong-excel\/"},"modified":"2025-01-15T03:06:57","modified_gmt":"2025-01-15T03:06:57","slug":"cach-them-cac-so-0-vao-dau-cac-gia-tri-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-them-cac-so-0-vao-dau-cac-gia-tri-trong-excel\/","title":{"rendered":"C\u00e1ch th\u00eam c\u00e1c s\u1ed1 0 v\u00e0o \u0111\u1ea7u c\u00e1c gi\u00e1 tr\u1ecb trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Trong b\u00e0i h\u01b0\u1edbng d\u1eabn l\u1ea7n n\u00e0y, <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1c gi\u1eef nguy\u00ean c\u00e1c s\u1ed1 0 \u1edf \u0111\u1ea7u chu\u1ed7i v\u0103n b\u1ea3n trong Excel, c\u00e1ch hi\u1ec3n th\u1ecb, lo\u1ea1i b\u1ecf hay \u1ea9n c\u00e1c s\u1ed1 0 \u0111\u00f3.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng Excel kh\u00f4ng ch\u1ec9 \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho t\u00ednh to\u00e1n m\u00e0 c\u00f2n \u0111\u1ec3 l\u01b0u c\u00e1c b\u1ea3n ghi nh\u01b0 m\u00e3 zip, s\u1ed1 b\u1ea3o m\u1eadt, ID c\u1ee7a nh\u00e2n vi\u00ean, ch\u1eafc ch\u1eafn b\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i gi\u1eef l\u1ea1i c\u00e1c con s\u1ed1 0 \u0111\u1ee9ng \u0111\u1ea7u c\u00e1c \u00f4. Tuy nhi\u00ean, n\u1ebfu b\u1ea1n nh\u1eadp m\u1ed9t m\u00e3 zip nh\u01b0 \u201c00123\u201d trong m\u1ed9t \u00f4 th\u00ec Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eaft th\u00e0nh \u201c123\u201d.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> V\u1ea5n \u0111\u1ec1 n\u00e0y x\u1ea3y ra do Microsoft Excel x\u1eed l\u00fd m\u00e3 b\u01b0u \u0111i\u1ec7n, s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u00e0 c\u00e1c m\u1ee5c t\u01b0\u01a1ng t\u1ef1 kh\u00e1c gi\u1ed1ng nh\u01b0 c\u00e1ch x\u1eed l\u00fd s\u1ed1, v\u00e0 t\u1ef1 \u0111\u1ed9ng \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng t\u1ed5ng qu\u00e1t nh\u01b0 \u0111\u1ed1i v\u1edbi c\u00e1c s\u1ed1 \u0111\u00f3 l\u00e0 t\u1ef1 x\u00f3a \u0111i c\u00e1c s\u1ed1 0 \u0111\u1ee9ng \u1edf \u0111\u1ea7u. May m\u1eafn l\u00e0 Excel c\u0169ng cung c\u1ea5p cho ch\u00fang ta ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ec3 c\u00f3 th\u1ec3 gi\u1eef l\u1ea1i nh\u1eefng s\u1ed1 0 \u0111\u1ee9ng \u1edf \u0111\u1ea7u c\u00e1c \u00f4. Trong b\u00e0i vi\u1ebft l\u1ea7n n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n ph\u01b0\u01a1ng ph\u00e1p \u0111\u00f3.<\/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-678726504ca67\" 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\/cach-cac-khong-vao-dau-cac-gia-tri-trong-excel.html#Cach_giu_lai_cac_so_khong_dung_dau_khi_nhap_vao_Excel\" title=\"C\u00e1ch gi\u1eef l\u1ea1i c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u khi nh\u1eadp v\u00e0o Excel\">C\u00e1ch gi\u1eef l\u1ea1i c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u khi nh\u1eadp v\u00e0o Excel<\/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\/cach-cac-khong-vao-dau-cac-gia-tri-trong-excel.html#Cach_hien_thi_so_khong_dung_dau_trong_Excel_bang_su_dung_dinh_dang_so_tuy_chinh\" title=\"C\u00e1ch hi\u1ec3n th\u1ecb s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u trong Excel b\u1eb1ng s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 t\u00f9y ch\u1ec9nh\">C\u00e1ch hi\u1ec3n th\u1ecb s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u trong Excel b\u1eb1ng s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 t\u00f9y ch\u1ec9nh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-cac-khong-vao-dau-cac-gia-tri-trong-excel.html#Cach_them_so_0_vao_dau_trong_Excel_su_dung_ham_TEXT\" title=\"C\u00e1ch th\u00eam s\u1ed1 0 v\u00e0o \u0111\u1ea7u trong Excel s\u1eed d\u1ee5ng h\u00e0m TEXT\">C\u00e1ch th\u00eam s\u1ed1 0 v\u00e0o \u0111\u1ea7u trong Excel s\u1eed d\u1ee5ng h\u00e0m TEXT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-cac-khong-vao-dau-cac-gia-tri-trong-excel.html#Cach_them_so_0_vao_dau_chuoi_van_ban\" title=\"C\u00e1ch th\u00eam s\u1ed1 0 v\u00e0o \u0111\u1ea7u chu\u1ed7i v\u0103n b\u1ea3n\">C\u00e1ch th\u00eam s\u1ed1 0 v\u00e0o \u0111\u1ea7u chu\u1ed7i v\u0103n b\u1ea3n<\/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\/cach-cac-khong-vao-dau-cac-gia-tri-trong-excel.html#Cong_thuc_1_Them_cac_so_0_vao_dau_su_dung_ham_RIGHT\" title=\"C\u00f4ng th\u1ee9c 1: Th\u00eam c\u00e1c s\u1ed1 0 v\u00e0o \u0111\u1ea7u s\u1eed d\u1ee5ng h\u00e0m RIGHT\">C\u00f4ng th\u1ee9c 1: Th\u00eam c\u00e1c s\u1ed1 0 v\u00e0o \u0111\u1ea7u s\u1eed d\u1ee5ng h\u00e0m RIGHT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-cac-khong-vao-dau-cac-gia-tri-trong-excel.html#Cong_thuc_2_Them_so_0_vao_dau_bang_cach_su_dung_ham_REPT_va_LEN\" title=\"C\u00f4ng th\u1ee9c 2: Th\u00eam s\u1ed1 0 v\u00e0o \u0111\u1ea7u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m REPT v\u00e0 LEN\">C\u00f4ng th\u1ee9c 2: Th\u00eam s\u1ed1 0 v\u00e0o \u0111\u1ea7u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m REPT v\u00e0 LEN<\/a><\/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\/cach-cac-khong-vao-dau-cac-gia-tri-trong-excel.html#Cach_hoat_dong_cua_cong_thuc_nay_nhu_sau\" title=\"C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y nh\u01b0 sau:\">C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y nh\u01b0 sau:<\/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\/cach-cac-khong-vao-dau-cac-gia-tri-trong-excel.html#Cach_them_mot_so_luong_so_khong_co_dinh_vao_dau_gia_tri\" title=\"C\u00e1ch th\u00eam m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng s\u1ed1 kh\u00f4ng c\u1ed1 \u0111\u1ecbnh v\u00e0o \u0111\u1ea7u gi\u00e1 tr\u1ecb\">C\u00e1ch th\u00eam m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng s\u1ed1 kh\u00f4ng c\u1ed1 \u0111\u1ecbnh v\u00e0o \u0111\u1ea7u gi\u00e1 tr\u1ecb<\/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-9\" href=\"https:\/\/blog.hocexcel.online\/cach-cac-khong-vao-dau-cac-gia-tri-trong-excel.html#Cach_loai_bo_so_khong_dung_dau_trong_Excel\" title=\"C\u00e1ch lo\u1ea1i b\u1ecf s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u trong Excel\">C\u00e1ch lo\u1ea1i b\u1ecf s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u trong Excel<\/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-10\" href=\"https:\/\/blog.hocexcel.online\/cach-cac-khong-vao-dau-cac-gia-tri-trong-excel.html#Loai_bo_cac_so_khong_dung_dau_bang_cach_thay_doi_dinh_dang_o\" title=\"Lo\u1ea1i b\u1ecf c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng \u00f4\">Lo\u1ea1i b\u1ecf c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng \u00f4<\/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\/cach-cac-khong-vao-dau-cac-gia-tri-trong-excel.html#Loai_bo_cac_so_khong_dung_dau_bang_cach_chuyen_sang_dang_so\" title=\"Lo\u1ea1i b\u1ecf c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u b\u1eb1ng c\u00e1ch chuy\u1ec3n sang d\u1ea1ng s\u1ed1\">Lo\u1ea1i b\u1ecf c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u b\u1eb1ng c\u00e1ch chuy\u1ec3n sang d\u1ea1ng s\u1ed1<\/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\/cach-cac-khong-vao-dau-cac-gia-tri-trong-excel.html#Loai_bo_cac_so_khong_dung_dau_bang_cach_su_dung_cong_thuc\" title=\"Lo\u1ea1i b\u1ecf c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c\">Lo\u1ea1i b\u1ecf c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c<\/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-13\" href=\"https:\/\/blog.hocexcel.online\/cach-cac-khong-vao-dau-cac-gia-tri-trong-excel.html#Cach_an_cac_so_khong_trong_Excel\" title=\"C\u00e1ch \u1ea9n c\u00e1c s\u1ed1 kh\u00f4ng trong Excel\">C\u00e1ch \u1ea9n c\u00e1c s\u1ed1 kh\u00f4ng trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_giu_lai_cac_so_khong_dung_dau_khi_nhap_vao_Excel\"><\/span><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">C\u00e1ch gi\u1eef l\u1ea1i c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u khi nh\u1eadp v\u00e0o Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">C\u00f3 m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 nh\u1eefng ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u l\u00e0m quen v\u1edbi Excel c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ec3 gi\u1eef l\u1ea1i nh\u1eefng s\u1ed1 0 \u0111\u1ee9ng \u0111\u1ea7u trong m\u1ed9t \u00f4, v\u00ed d\u1ee5 nh\u01b0 01. \u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y, ch\u00fang ta ch\u1ec9 c\u1ea7n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng \u00f4 th\u00e0nh Text:<\/span><\/p>\n<p><span style=\"color: #d83131\"><strong>C\u00e1ch 1:\u00a0<\/strong><\/span><\/p>\n<ul style=\"text-align: justify\">\n<li><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Ch\u1ecdn 1 ho\u1eb7c nhi\u1ec1u \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n nh\u1eadp s\u1ed1 v\u1edbi s\u1ed1 \u0111\u1ea7u ti\u00ean l\u00e0 0<\/span><\/li>\n<li><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">T\u1edbi ph\u1ea7n <strong>Trang ch\u1ee7 (Home tab) &gt; Number group, r\u1ed3i ch\u1ecdn Text.<\/strong><\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Ngay khi b\u1ea1n nh\u1eadp m\u1ed9t s\u1ed1 b\u1eaft \u0111\u1ea7u b\u1eb1ng s\u1ed1 0, Excel s\u1ebd hi\u1ec3n th\u1ecb m\u1ed9t h\u00ecnh tam gi\u00e1c nh\u1ecf m\u00e0u xanh l\u00e1 \u1edf g\u00f3c tr\u00ean c\u00f9ng b\u00ean tr\u00e1i c\u1ee7a \u00f4 th\u1ec3 hi\u1ec7n \u0111i\u1ec1u n\u00e0y kh\u00f4ng h\u1ee3p l\u1ec7. \u0110\u1ec3 lo\u1ea1i b\u1ecf tam gi\u00e1c \u0111\u00f3, b\u1ea1n ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u \u00f4 c\u1ea7n quan t\u00e2m r\u1ed3i nh\u1ea5p v\u00e0o d\u1ea5u hi\u1ec7u c\u1ea3nh b\u00e1o, sau \u0111\u00f3 ch\u1ecdn <strong>Ignore Error.<\/strong><\/span><\/p>\n<figure id=\"attachment_6325\" aria-describedby=\"caption-attachment-6325\" style=\"width: 249px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6325 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/0001.png\" alt=\"Loi-nhap-so-khong-hop-le-trong-Excel\" width=\"249\" height=\"183\" title=\"0001\"><figcaption id=\"caption-attachment-6325\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">Loi-nhap-so-khong-hop-le-trong-Excel<\/span><\/figcaption><\/figure>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> C\u00e1c b\u1ea1n xem th\u00eam h\u00ecnh b\u00ean d\u01b0\u1edbi \u0111\u1ec3 th\u1ea5y k\u1ebft qu\u1ea3<\/span><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-40.gif\" title=\"vba101_92019-nho-40\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-295.gif\" title=\"ex101_92019-nho-295\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_6326\" aria-describedby=\"caption-attachment-6326\" style=\"width: 419px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6326 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/0002.png\" alt=\"Xoa-dau-hieu-bao-loi\" width=\"419\" height=\"169\" title=\"0002\"><figcaption id=\"caption-attachment-6326\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">Xoa-dau-hieu-bao-loi<\/span><\/figcaption><\/figure>\n<p><span style=\"color: #d83131\"><strong>C\u00e1ch 2:\u00a0<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 gi\u1eef \u0111\u01b0\u1ee3c nh\u1eefng s\u1ed1 0 \u0111\u1ee9ng \u1edf \u0111\u1ea7u trong Excel l\u00e0 \u0111\u1eb7t \u1edf tr\u01b0\u1edbc n\u00f3 m\u1ed9t d\u1ea5u nh\u00e1y (\u2018). V\u00ed d\u1ee5 nh\u01b0, thay v\u00ec g\u00f5 01, b\u1ea1n g\u00f5 l\u00e0 \u201901, nh\u01b0 v\u1eady b\u1ea1n s\u1ebd kh\u00f4ng c\u1ea7n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 \u0111\u00f3.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">L\u01b0u \u00fd: C\u00e1ch l\u00e0m n\u00e0y c\u00f3 ch\u00fat gi\u1edbi h\u1ea1n \u0111\u00f3 l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a chu\u1ed7i v\u0103n b\u1ea3n \u0111\u00f3 s\u1ebd kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1, do \u0111\u00f3 kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m ph\u00e9p t\u00ednh v\u00e0 kh\u00f4ng \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c c\u00e1c c\u00f4ng th\u1ee9c s\u1ed1. N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n x\u1ea3y ra t\u00ecnh tr\u1ea1ng \u0111\u00f3 th\u00ec b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i c\u00e1c bi\u1ec3u th\u1ecb gi\u00e1 tr\u1ecb tr\u1ef1c quan b\u1eb1ng c\u00e1ch \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 t\u00f9y ch\u1ec9nh nh\u01b0 v\u00ed d\u1ee5 minh h\u1ecda ti\u1ebfp sau \u0111\u00e2y.<\/span><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_hien_thi_so_khong_dung_dau_trong_Excel_bang_su_dung_dinh_dang_so_tuy_chinh\"><\/span><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">C\u00e1ch hi\u1ec3n th\u1ecb s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u trong Excel b\u1eb1ng s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 t\u00f9y ch\u1ec9nh<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">\u0110\u1ec3 hi\u1ec3n th\u1ecb s\u1ed1 0 \u0111\u1ee9ng \u0111\u1ea7u, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 t\u00f9y ch\u1ec9nh b\u1eb1ng c\u00e1ch th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<ol style=\"text-align: justify\">\n<li><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u \u00f4 b\u1ea1n c\u1ea7n hi\u1ec3n th\u1ecb s\u1ed1 0 \u1edf \u0111\u00e2u v\u00e0 nh\u1ea5n <code class=\"excel-formula-inline\"><strong>ctrl + 1<\/strong><\/code> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <code class=\"excel-formula-inline\"><strong>Format Cells<\/strong><\/code>.<\/span><\/li>\n<li><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Trong ph\u1ea7n<strong> Category<\/strong>, ch\u1ecdn <strong>Custom.<\/strong><\/span><\/li>\n<li><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Nh\u1eadp m\u00e3 \u0111\u1ecbnh d\u1ea1ng v\u00e0o ph\u1ea7n<strong> Type.<\/strong><br \/>\nTrong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n s\u1ebd c\u1ea7n m\u1ed9t m\u00e3 \u0111\u1ecbnh d\u1ea1ng v\u1edbi k\u00fd t\u1ef1 0, v\u00ed d\u1ee5 nh\u01b0 00. S\u1ed1 s\u1ed1 0 trong m\u00e3 \u0111\u1ecbnh d\u1ea1ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi t\u1ed5ng s\u1ed1 ch\u1eef s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb trong m\u1ed9t \u00f4 (c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y).<\/span><\/li>\n<li><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Nh\u1ea5p v\u00e0o <strong>OK<\/strong> \u0111\u1ec3 l\u01b0u thay \u0111\u1ed5i.<\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"><strong> V\u00ed d\u1ee5<\/strong>: \u0111\u1ec3 th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u nh\u1eb1m t\u1ea1o m\u1ed9t s\u1ed1 c\u00f3 5 ch\u1eef s\u1ed1, b\u1ea1n s\u1eed d\u1ee5ng m\u00e3 \u0111\u1ecbnh d\u1ea1ng 00000<\/span><\/p>\n<figure id=\"attachment_6327\" aria-describedby=\"caption-attachment-6327\" style=\"width: 486px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6327 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/0003.png\" alt=\"Dinh-dang-so-tuy-chinh-trong-Excel\" width=\"486\" height=\"509\" title=\"0003\"><figcaption id=\"caption-attachment-6327\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">Dinh-dang-so-tuy-chinh-trong-Excel<\/span><\/figcaption><\/figure>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">T\u1eeb vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c \u0111\u1ecbnh d\u1ea1ng s\u1ed1 t\u00f9y ch\u1ec9nh c\u1ee7a Excel, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam c\u00e1c s\u1ed1 0 v\u00e0o \u0111\u1ea7u \u0111\u1ec3 t\u1ea1o c\u00e1c s\u1ed1 c\u00f3 \u0111\u1ed9 d\u00e0i c\u1ed1 \u0111\u1ecbnh, gi\u1ed1ng nh\u01b0 v\u00ed d\u1ee5 b\u00ean tr\u00ean, v\u00e0 c\u1ea3 c\u00e1c s\u1ed1 c\u00f3 \u0111\u1ed9 d\u00e0i kh\u00f4ng c\u1ed1 \u0111\u1ecbnh. T\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ec1u \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u1edd vi\u1ec7c s\u1eed d\u1ee5ng m\u00e3 \u0111\u1ecbnh d\u1ea1ng:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> <strong> 0<\/strong> \u2013 hi\u1ec3n th\u1ecb th\u00eam s\u1ed1 kh\u00f4ng<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> <strong> #<\/strong> \u2013 kh\u00f4ng hi\u1ec3n th\u1ecb s\u1ed1 0 th\u00eam v\u00e0o<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng #000 v\u1edbi m\u1ed9t s\u1ed1 \u00f4, d\u00f9 b\u1ea1n nh\u1eadp v\u00e0o s\u1ed1 n\u00e0o th\u00ec s\u1ed1 \u0111\u00f3 s\u1ebd c\u00f3 th\u00eam 3 s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u1edf \u0111\u1ea7u.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> C\u00e1c \u0111\u1ecbnh d\u1ea1ng s\u1ed1 t\u00f9y ch\u1ec9nh c\u1ee7a b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 bao g\u1ed3m c\u1ea3 d\u1ea5u c\u00e1ch, d\u1ea5u g\u1ea1ch ngang, d\u1ea5u ngo\u1eb7c \u0111\u01a1n,\u2026.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> B\u1ea3ng t\u00ednh sau \u0111\u00e2y s\u1ebd cho b\u1ea1n th\u1ea5y v\u00ed d\u1ee5 v\u1ec1 c\u00e1c \u0111\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c s\u1ed1 0 \u0111\u1ee9ng \u0111\u1ea7u trong Excel.<\/span><\/p>\n<figure id=\"attachment_6328\" aria-describedby=\"caption-attachment-6328\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6328\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/0004.png\" alt=\"Dinh-dang-so-tuy-chinh\" width=\"600\" height=\"285\" title=\"0004\"><figcaption id=\"caption-attachment-6328\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">Dinh-dang-so-tuy-chinh<\/span><\/figcaption><\/figure>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">C\u00e1c m\u00e3 \u0111\u1ecbnh d\u1ea1ng sau c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 hi\u1ec3n th\u1ecb s\u1ed1 \u1edf c\u00e1c \u0111\u1ecbnh d\u1ea1ng \u0111\u1eb7c bi\u1ec7t nh\u01b0 m\u00e3 zip, s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, s\u1ed1 th\u1ebb t\u00edn d\u1ee5ng v\u00e0 s\u1ed1 an sinh x\u00e3 h\u1ed9i.<\/span><\/p>\n<figure id=\"attachment_6329\" aria-describedby=\"caption-attachment-6329\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6329\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/0005.png\" alt=\"mot-so-ma-dinh-dang-so-tuy-chinh\" width=\"600\" height=\"154\" title=\"0005\"><figcaption id=\"caption-attachment-6329\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">mot-so-ma-dinh-dang-so-tuy-chinh<\/span><\/figcaption><\/figure>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"><strong>M\u1eb9o:<\/strong> Excel c\u00f3 m\u1ed9t v\u00e0i \u0111\u1ecbnh d\u1ea1ng \u0111\u01b0\u1ee3c \u0111\u1eb7t s\u1eb5n cho c\u00e1c m\u00e3 b\u01b0u \u0111i\u1ec7n, s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u00e0 s\u1ed1 an sinh x\u00e3 h\u1ed9i, th\u1ec3 hi\u1ec7n qua h\u00ecnh b\u00ean d\u01b0\u1edbi:<\/span><\/p>\n<figure id=\"attachment_6330\" aria-describedby=\"caption-attachment-6330\" style=\"width: 548px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6330 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/0006.png\" alt=\"ma-dinh-dang-cho-san\" width=\"548\" height=\"473\" title=\"0006\"><figcaption id=\"caption-attachment-6330\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">ma-dinh-dang-cho-san<\/span><\/figcaption><\/figure>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"><strong>L\u01b0u \u00fd<\/strong>: Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y t\u1ed1t nh\u1ea5t l\u00e0 s\u1eed d\u1ee5ng trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi m\u1ed9t t\u1eadp h\u1ee3p d\u1eef li\u1ec7u s\u1ed1 v\u00e0 k\u1ebft qu\u1ea3 l\u00e0 c\u00e1c con s\u1ed1 ch\u1ee9 kh\u00f4ng ph\u1ea3i v\u0103n b\u1ea3n. C\u00e1ch n\u00e0y ch\u1ec9 l\u00e0m thay \u0111\u1ed5i hi\u1ec3n th\u1ecb c\u1ee7a m\u1ed9t s\u1ed1 nh\u01b0ng kh\u00f4ng ph\u1ea3i thay \u0111\u1ed5i h\u1eb3n s\u1ed1 \u0111\u00f3: d\u00f9 c\u00f3 th\u00eam c\u00e1c s\u1ed1 0 hi\u1ec3n th\u1ecb \u1edf trong c\u00e1c \u00f4 nh\u01b0ng gi\u00e1 tr\u1ecb th\u1ef1c s\u1ef1 c\u1ee7a s\u1ed1 ban \u0111\u1ea7u th\u00ec v\u1eabn gi\u1eef nguy\u00ean. Khi \u00e1p d\u1ee5ng t\u00ednh to\u00e1n c\u00e1c \u00f4 ch\u1ee9a nh\u1eefng s\u1ed1 \u0111\u00f3 th\u00ec ph\u00e9p t\u00ednh s\u1ebd th\u1ef1c hi\u1ec7n v\u1edbi gi\u00e1 tr\u1ecb ban \u0111\u1ea7u. C\u00e1c \u0111\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c cho d\u1eef li\u1ec7u s\u1ed1 (g\u1ed3m c\u00e1c con s\u1ed1 v\u00e0 ng\u00e0y th\u00e1ng) v\u00e0 k\u1ebft qu\u1ea3 cho ra c\u0169ng s\u1ebd l\u00e0 c\u00e1c con s\u1ed1 ho\u1eb7c ng\u00e0y th\u00e1ng.<\/span><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_them_so_0_vao_dau_trong_Excel_su_dung_ham_TEXT\"><\/span><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">C\u00e1ch th\u00eam s\u1ed1 0 v\u00e0o \u0111\u1ea7u trong Excel s\u1eed d\u1ee5ng h\u00e0m TEXT<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">\u0110\u1ecbnh d\u1ea1ng s\u1ed1 t\u00f9y ch\u1ec9nh cho ph\u00e9p hi\u1ec3n th\u1ecb s\u1ed1 0 \u1edf ph\u00eda tr\u01b0\u1edbc c\u1ee7a m\u1ed9t s\u1ed1 m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i gi\u00e1 tr\u1ecb c\u01a1 b\u1ea3n c\u1ee7a s\u1ed1 \u0111\u00f3, c\u00f2n <strong>h\u00e0m Excel TEXT<\/strong> th\u00ec th\u00eam s\u1ed1 0 v\u00e0o s\u1ed1 ban \u0111\u1ea7u theo d\u1ea1ng l\u00e0m thay \u0111\u1ed5i c\u1ea3 b\u1ea3n ch\u1ea5t c\u1ee7a s\u1ed1 \u0111\u00f3.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> \u0110\u1ec3 th\u00eam c\u00e1c s\u1ed1 kh\u00f4ng v\u00e0o \u0111\u1ea7u m\u1ed9t s\u1ed1 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c TEXT(value, format_text), b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c m\u00e3 \u0111\u1ecbnh d\u1ea1ng gi\u1ed1ng nh\u01b0 \u1edf c\u00e1c \u0111\u1ecbnh d\u1ea1ng s\u1ed1 t\u00f9y ch\u1ec9nh. Tuy nhi\u00ean, k\u1ebft qu\u1ea3 c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/ham-text-va-cac-ung-dung-tuyet-voi-cua-ham-text-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>h\u00e0m TEXT<\/strong><\/a> lu\u00f4n lu\u00f4n l\u00e0 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, ngay c\u1ea3 khi tr\u00f4ng h\u00ecnh th\u1ee9c c\u1ee7a n\u00f3 gi\u1ed1ng nh\u01b0 m\u1ed9t s\u1ed1.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> <strong> V\u00ed d\u1ee5<\/strong>, \u0111\u1ec3 ch\u00e8n s\u1ed1 0 v\u00e0o tr\u01b0\u1edbc m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 A2, ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:<\/span><br \/>\n<span style=\"font-size: 12pt;font-family: georgia, palatino, serif\"> <strong> = TEXT (A2, \u201c0 #\u201d)<\/strong><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> \u0110\u1ec3 t\u1ea1o chu\u1ed7i s\u1ed1 0 \u0111\u1ee9ng ph\u00eda tr\u01b0\u1edbc v\u1edbi \u0111\u1ed9 d\u00e0i c\u1ed1 \u0111\u1ecbnh l\u00e0 5 k\u00fd t\u1ef1 th\u00ec ta s\u1eed d\u1ee5ng chu\u1ed7i sau:<\/span><br \/>\n<span style=\"font-size: 12pt;font-family: georgia, palatino, serif\"> <strong> = TEXT (A2, \u201c000000\u201d)<\/strong><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> B\u1ea1n c\u0169ng c\u1ea7n l\u01b0u \u00fd r\u1eb1ng <strong>h\u00e0m TEXT<\/strong> c\u1ea7n ph\u1ea3i c\u00f3 m\u00e3 \u0111\u1ecbnh d\u1ea1ng n\u1eb1m k\u00e8m trong d\u1ea5u ngo\u1eb7c k\u00e9p v\u00e0 k\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c nh\u01b0 sau:<\/span><\/p>\n<figure id=\"attachment_6331\" aria-describedby=\"caption-attachment-6331\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6331\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/0007.png\" alt=\"su-dung-ham-text\" width=\"600\" height=\"217\" title=\"0007\"><figcaption id=\"caption-attachment-6331\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">su-dung-ham-text<\/span><\/figcaption><\/figure>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"><strong>L\u01b0u \u00fd:<\/strong> H\u00e0m Excel TEXT lu\u00f4n tr\u1ea3 v\u1ec1 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n ch\u1ee9 kh\u00f4ng ph\u1ea3i s\u1ed1, do \u0111\u00f3 b\u1ea1n kh\u00f4ng th\u1ec3 d\u00f9ng trong c\u00e1c k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n s\u1ed1 h\u1ecdc v\u00e0 c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c, m\u00e0 ch\u1ec9 d\u00f9ng \u0111\u1ec3 so s\u00e1nh k\u1ebft qu\u1ea3 \u0111\u1ea7u ra v\u1edbi c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n kh\u00e1c.<\/span><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_them_so_0_vao_dau_chuoi_van_ban\"><\/span><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">C\u00e1ch th\u00eam s\u1ed1 0 v\u00e0o \u0111\u1ea7u chu\u1ed7i v\u0103n b\u1ea3n<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Trong c\u00e1c v\u00ed d\u1ee5 tr\u01b0\u1edbc, c\u00e1c b\u1ea1n \u0111\u00e3 th\u1ea5y c\u00e1ch th\u00eam s\u1ed1 0 v\u00e0o tr\u01b0\u1edbc m\u1ed9t s\u1ed1 trong Excel. V\u1eady n\u1ebfu b\u1ea1n mu\u1ed1n th\u00eam s\u1ed1 0 v\u00e0o tr\u01b0\u1edbc m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, v\u00ed d\u1ee5 nh\u01b0 0A102 th\u00ec sao? Trong tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3, c\u1ea3 h\u00e0m TEXT l\u1eabn \u0111\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh \u0111\u1ec1u s\u1ebd kh\u00f4ng c\u00f3 t\u00e1c d\u1ee5ng v\u00ec ch\u00fang ch\u1ec9 c\u00f3 th\u1ec3 x\u1eed l\u00fd \u0111\u01b0\u1ee3c c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> N\u1ebfu gi\u00e1 tr\u1ecb c\u1ea7n th\u00eam 0 v\u00e0o c\u00f3 ch\u1ee9a c\u00e1c k\u00fd t\u1ef1 ch\u1eef ho\u1eb7c v\u0103n b\u1ea3n th\u00ec c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng m\u1ed9t trong nh\u1eefng c\u00e1ch sau, nh\u1eefng c\u00e1ch n\u00e0y l\u00e0 gi\u1ea3i ph\u00e1p ph\u1ed5 qu\u00e1t cho c\u1ea3 s\u1ed1 v\u00e0 chu\u1ed7i v\u0103n b\u1ea3n.<\/span><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_1_Them_cac_so_0_vao_dau_su_dung_ham_RIGHT\"><\/span><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">C\u00f4ng th\u1ee9c 1: Th\u00eam c\u00e1c s\u1ed1 0 v\u00e0o \u0111\u1ea7u s\u1eed d\u1ee5ng h\u00e0m RIGHT<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">C\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 \u0111\u1eb7t s\u1ed1 0 l\u00ean \u0111\u1ea7u tr\u01b0\u1edbc c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n trong Excel ch\u00ednh l\u00e0 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m RIGHT<\/a>:<\/span><br \/>\n<span style=\"font-size: 12pt;font-family: georgia, palatino, serif\"> <strong> <code class=\"excel-formula-inline\">RIGHT(\"0000\" &amp; cell, string_length)<\/code><\/strong><\/span><br \/>\n<span style=\"font-size: 12pt;font-family: georgia, palatino, serif\"> <strong> Trong \u0111\u00f3:<\/strong><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> <strong> \u201c0000\u201d<\/strong> l\u00e0 s\u1ed1 s\u1ed1 kh\u00f4ng t\u1ed1i \u0111a m\u00e0 b\u1ea1n mu\u1ed1n th\u00eam v\u00e0o. V\u00ed d\u1ee5: \u0111\u1ec3 th\u00eam v\u00e0o 2 s\u1ed1 0 th\u00ec b\u1ea1n nh\u1eadp \u201c00\u201d.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> <strong> Cell<\/strong> l\u00e0 m\u1ed9t \u00f4 tham chi\u1ebfu \u0111\u1ebfn \u00f4 c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb ban \u0111\u1ea7u.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> <strong> String_length<\/strong> l\u00e0 s\u1ed1 k\u00fd t\u1ef1 m\u00e0 chu\u1ed7i k\u1ebft qu\u1ea3 ph\u1ea3i ch\u1ee9a.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> <strong> V\u00ed d\u1ee5:<\/strong> \u0111\u1ec3 t\u1ea1o chu\u1ed7i k\u00fd t\u1ef1 g\u1ed3m 6 k\u00fd t\u1ef1 kh\u00f4ng c\u00f3 ti\u1ec1n t\u1ed1 d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb trong \u00f4 A2 th\u00ec b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:<\/span><br \/>\n<span style=\"font-size: 12pt;font-family: georgia, palatino, serif\"> <strong> = RIGHT (\u201c000000\u201d &amp; A2, 6)<\/strong><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y l\u00e0 th\u00eam v\u00e0o 6 con s\u1ed1 kh\u00f4ng v\u00e0o gi\u00e1 tr\u1ecb ch\u1ee9a trong \u00f4 A2 (\u201c000000\u2033&amp;A2), sau \u0111\u00f3 l\u1ea5y ra \u0111\u00fang 6 k\u00fd t\u1ef1. K\u1ebft qu\u1ea3 l\u00e0 n\u00f3 ch\u1ec9 ch\u00e8n \u0111\u00fang s\u1ed1 s\u1ed1 kh\u00f4ng \u0111\u1ee7 \u0111\u1ec3 \u0111\u1ea1t \u0111\u1ebfn gi\u1edbi h\u1ea1n t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 trong chu\u1ed7i.<\/span><\/p>\n<figure id=\"attachment_6332\" aria-describedby=\"caption-attachment-6332\" style=\"width: 509px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6332 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/0008.png\" alt=\"chen-so-khong-su-dung-ham-right\" width=\"509\" height=\"497\" title=\"0008\"><figcaption id=\"caption-attachment-6332\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">chen-so-khong-su-dung-ham-right<\/span><\/figcaption><\/figure>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Trong v\u00ed d\u1ee5 tr\u00ean, s\u1ed1 s\u1ed1 kh\u00f4ng t\u1ed1i \u0111a b\u1eb1ng t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1 (6 k\u00fd t\u1ef1), v\u00ec th\u1ebf t\u1ea5t c\u1ea3 c\u00e1c chu\u1ed7i k\u1ebft qu\u1ea3 \u0111\u1ec1u c\u00f3 chi\u1ec1u d\u00e0i l\u00e0 6 k\u00fd t\u1ef1 (chi\u1ec1u d\u00e0i c\u1ed1 \u0111\u1ecbnh). N\u1ebfu \u00e1p d\u1ee5ng cho m\u1ed9t \u00f4 tr\u1ed1ng th\u00ec c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t chu\u1ed7i g\u1ed3m 6 s\u1ed1 kh\u00f4ng.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> Tuy thu\u1ed9c v\u00e0o m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng, b\u1ea1n c\u00f3 th\u1ec3 ch\u00e8n th\u00eam s\u1ed1 s\u1ed1 kh\u00f4ng kh\u00e1c nhau v\u00e0 thay \u0111\u1ed5i t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 theo \u00fd mu\u1ed1n, v\u00ed d\u1ee5:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\"><strong>=RIGHT(\u201c00\u2033&amp;A2, 6)<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c l\u00e0 chu\u1ed7i c\u00f3 chi\u1ec1u d\u00e0i thay \u0111\u1ed5i, c\u00f3 th\u1ec3 ch\u1ee9a t\u1ed1i \u0111a 2 s\u1ed1 kh\u00f4ng \u1edf \u0111\u1ea7u:<\/span><\/p>\n<figure id=\"attachment_6333\" aria-describedby=\"caption-attachment-6333\" style=\"width: 518px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6333 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/0009.png\" alt=\"ket-qua-nhan-duoc-khi-chen-so-khong-dung-ham-right\" width=\"518\" height=\"327\" title=\"0009\"><figcaption id=\"caption-attachment-6333\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">ket-qua-nhan-duoc-khi-chen-so-khong-dung-ham-right<\/span><\/figcaption><\/figure>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_2_Them_so_0_vao_dau_bang_cach_su_dung_ham_REPT_va_LEN\"><\/span><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">C\u00f4ng th\u1ee9c 2: Th\u00eam s\u1ed1 0 v\u00e0o \u0111\u1ea7u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m REPT v\u00e0 LEN<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 ch\u00e8n s\u1ed1 0 v\u00e0o tr\u01b0\u1edbc m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n trong Excel l\u00e0 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p <a href=\"http:\/\/blog.ezworkapp.com\/ham-lap-lai-chuoi-tu-ky-tu-hoac-so-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m REPT<\/a> v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-len-ham-dem-so-ky-tu-trong-chuoi.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m \u00a0LEN<\/a>:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\"><strong><code class=\"excel-formula-inline\">REPT(0, number of zeros-LEN(cell))&amp;cell<\/code><\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"><strong>V\u00ed d\u1ee5<\/strong>, \u0111\u1ec3 th\u00eam c\u00e1c s\u1ed1 0 v\u00e0o m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 A2 \u0111\u1ec3 t\u1ea1o chu\u1ed7i g\u1ed3m 6 k\u00fd t\u1ef1, b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:<\/span><br \/>\n<span style=\"font-size: 12pt;font-family: georgia, palatino, serif\"> <strong> =REPT(0, 6-LEN(A2))&amp;A2<\/strong><\/span><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_hoat_dong_cua_cong_thuc_nay_nhu_sau\"><\/span><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y nh\u01b0 sau:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">H\u00e0m REPT l\u1eb7p l\u1ea1i m\u1ed9t k\u00fd t\u1ef1 cho tr\u01b0\u1edbc m\u1ed9t s\u1ed1 l\u1ea7n nh\u1ea5t \u0111\u1ecbnh v\u00e0 LEN tr\u1ea3 v\u1ec1 t\u1ed5ng chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1, n\u00ean ta c\u00f3 c\u00f4ng th\u1ee9c d\u1ec5 hi\u1ec3u theo logic:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">LEN(A2) nh\u1eadn t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 trong \u00f4 A2<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> REPT(0, 6-LEN(A2)) th\u00eam v\u00e0o s\u1ed1 s\u1ed1 kh\u00f4ng c\u1ea7n thi\u1ebft. \u0110\u1ec3 t\u00ednh xem c\u1ea7n th\u00eam v\u00e0o bao nhi\u00eau s\u1ed1 0, b\u1ea1n l\u1ea5y s\u1ed1 s\u1ed1 kh\u00f4ng c\u1ef1c \u0111\u1ea1i tr\u1eeb \u0111i chi\u1ec1u d\u00e0i c\u1ee7a chu\u1ed7i trong \u00f4 A2. Cu\u1ed1i c\u00f9ng, ta nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3:<\/span><\/p>\n<figure id=\"attachment_6334\" aria-describedby=\"caption-attachment-6334\" style=\"width: 477px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6334 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/00010.png\" alt=\"Ham-REPT-va-LEN\" width=\"477\" height=\"483\" title=\"00010\"><figcaption id=\"caption-attachment-6334\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">Ham-REPT-va-LEN<\/span><\/figcaption><\/figure>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"><strong>L\u01b0u \u00fd<\/strong>: C\u00f4ng th\u1ee9c n\u00e0y c\u00f3 th\u1ec3 th\u00eam c\u00e1c s\u1ed1 kh\u00f4ng v\u00e0o \u0111\u1ea7u chu\u1ed7i v\u0103n b\u1ea3n ho\u1eb7c s\u1ed1 nh\u01b0ng k\u1ebft qu\u1ea3 l\u1ea1i lu\u00f4n l\u00e0 v\u0103n b\u1ea3n ch\u1ee9 kh\u00f4ng ph\u1ea3i s\u1ed1.<\/span><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_them_mot_so_luong_so_khong_co_dinh_vao_dau_gia_tri\"><\/span><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">C\u00e1ch th\u00eam m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng s\u1ed1 kh\u00f4ng c\u1ed1 \u0111\u1ecbnh v\u00e0o \u0111\u1ea7u gi\u00e1 tr\u1ecb<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">\u0110\u1ec3 th\u00eam ti\u1ec1n t\u1ed1 v\u00e0o t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb trong c\u1ed9t (c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 ho\u1eb7c chu\u1ed7i v\u0103n b\u1ea3n) v\u1edbi s\u1ed1 l\u01b0\u1ee3ng s\u1ed1 kh\u00f4ng c\u1ed1 \u0111\u1ecbnh s\u1eb5n, b\u1ea1n s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-concatenate-trong-excel-ung-dung-de-noi-cac-chuoi-o-mang-va-cot.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m CONCATENATE<\/a> ho\u1eb7c h\u00e0m to\u00e1n t\u1eed.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> V\u00ed d\u1ee5, \u0111\u1ec3 \u0111\u1eb7t 0 tr\u01b0\u1edbc m\u1ed9t s\u1ed1 trong \u00f4 A2, s\u1eed d\u1ee5ng nh\u1eefng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\"><strong>=CONCATENATE(0,A2)<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">ho\u1eb7c<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\"><strong>=0&amp;A2<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Nh\u01b0 nh\u1eefng g\u00ec hi\u1ec3n th\u1ecb trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi, c\u00f4ng th\u1ee9c th\u00eam ch\u1ec9 m\u1ed9t s\u1ed1 0 v\u00e0o \u0111\u1ea7u h\u00e0ng cho t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong m\u1ed9t c\u1ed9t d\u00f9 ban \u0111\u1ea7u nh\u1eefng \u00f4 \u0111\u00f3 ch\u1ee9a bao nhi\u00eau k\u00fd t\u1ef1.<\/span><\/p>\n<figure id=\"attachment_6335\" aria-describedby=\"caption-attachment-6335\" style=\"width: 463px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6335 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/00011.png\" alt=\"them-khong-dung-ham-concatenate\" width=\"463\" height=\"305\" title=\"00011\"><figcaption id=\"caption-attachment-6335\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">them-khong-dung-ham-concatenate<\/span><\/figcaption><\/figure>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 ch\u00e8n th\u00eam 2 s\u1ed1 kh\u00f4ng (00), 3 s\u1ed1 kh\u00f4ng (000) ho\u1eb7c nhi\u1ec1u s\u1ed1 kh\u00f4ng tr\u01b0\u1edbc c\u00e1c s\u1ed1 ho\u1eb7c chu\u1ed7i v\u0103n b\u1ea3n.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"><strong>L\u01b0u \u00fd<\/strong>: K\u1ebft c\u1ee7a c\u1ee7a c\u00f4ng th\u1ee9c n\u00e0y c\u0169ng l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n k\u1ec3 c\u1ea3 khi gi\u00e1 tr\u1ecb ban \u0111\u1ea7u \u0111\u01b0\u1ee3c th\u00eam v\u00e0o l\u00e0 s\u1ed1.<\/span><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_loai_bo_so_khong_dung_dau_trong_Excel\"><\/span><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">C\u00e1ch lo\u1ea1i b\u1ecf s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Ph\u01b0\u01a1ng ph\u00e1p b\u1ea1n s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00f3a c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u trong Excel ph\u1ee5 thu\u1ed9c v\u00e0o c\u00e1ch m\u00e0 c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u00f3 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">\u2013 N\u1ebfu tr\u01b0\u1edbc \u0111\u00f3, c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o b\u1eb1ng c\u00e1ch d\u00f9ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 t\u00f9y ch\u1ec9nh (s\u1ed1 kh\u00f4ng c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y \u0111\u01b0\u1ee3c trong m\u1ed9t \u00f4, nh\u01b0ng kh\u00f4ng hi\u1ec3n th\u1ecb tr\u00ean thanh c\u00f4ng th\u1ee9c) th\u00ec b\u1ea1n \u00e1p d\u1ee5ng m\u1ed9t \u0111\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh kh\u00e1c ho\u1eb7c \u0111\u1eb7t l\u1ea1i \u0111\u1ecbnh d\u1ea1ng General nh\u01b0 b\u00ean d\u01b0\u1edbi.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> \u2013 N\u1ebfu c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o \u00f4 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u1edf m\u1ee5c Text (xu\u1ea5t hi\u1ec7n tam gi\u00e1c nh\u1ecf m\u00e0u xanh l\u00e1 c\u00e2y \u1edf g\u00f3c tr\u00ean c\u00f9ng b\u00ean tr\u00e1i c\u1ee7a \u00f4), b\u1ea1n chuy\u1ec3n v\u0103n b\u1ea3n \u0111\u00f3 sang d\u1ea1ng s\u1ed1.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> \u2013 N\u1ebfu c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c (c\u00f4ng th\u1ee9c xu\u1ea5t hi\u1ec7n trong thanh c\u00f4ng th\u1ee9c khi nh\u1ea5n ch\u1ecdn \u00f4 \u0111\u00f3), b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m VALUE \u0111\u1ec3 lo\u1ea1i b\u1ecf ch\u00fang.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">C\u00e1c b\u1ea1n xem h\u00ecnh b\u00ean d\u01b0\u1edbi \u0111\u1ec3 hi\u1ec3u h\u01a1n v\u1ec1 3 tr\u01b0\u1eddng h\u1ee3p tr\u00ean v\u00e0 l\u1ef1a ch\u1ecdn c\u00e1ch l\u00e0m ph\u00f9 h\u1ee3p.<\/span><\/p>\n<figure id=\"attachment_6336\" aria-describedby=\"caption-attachment-6336\" style=\"width: 607px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6336 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/00012.png\" alt=\"loai-bo-so-khong-dung-dau-gia-tri\" width=\"607\" height=\"203\" title=\"00012\"><figcaption id=\"caption-attachment-6336\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">loai-bo-so-khong-dung-dau-gia-tri<\/span><\/figcaption><\/figure>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Loai_bo_cac_so_khong_dung_dau_bang_cach_thay_doi_dinh_dang_o\"><\/span><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Lo\u1ea1i b\u1ecf c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng \u00f4<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">N\u1ebfu c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong c\u00e1c \u00f4 c\u00f3 \u0111\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh, b\u1ea1n h\u00e3y thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng \u00f4, \u0111\u1eb7t l\u1ea1i th\u00e0nh m\u1eb7c \u0111\u1ecbnh chung ho\u1eb7c \u00e1p d\u1ee5ng m\u1ed9t \u0111\u1ecbnh d\u1ea1ng kh\u00e1c kh\u00f4ng \u0111\u1ec3 s\u1ed1 kh\u00f4ng hi\u1ec3n th\u1ecb \u1edf \u0111\u1ea7u gi\u00e1 tr\u1ecb \u00f4.<\/span><\/p>\n<figure id=\"attachment_6337\" aria-describedby=\"caption-attachment-6337\" style=\"width: 563px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6337 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/00013.png\" alt=\"thay-doi-dinh-dang-o\" width=\"563\" height=\"268\" title=\"00013\"><figcaption id=\"caption-attachment-6337\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">thay-doi-dinh-dang-o<\/span><\/figcaption><\/figure>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Loai_bo_cac_so_khong_dung_dau_bang_cach_chuyen_sang_dang_so\"><\/span><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Lo\u1ea1i b\u1ecf c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u b\u1eb1ng c\u00e1ch chuy\u1ec3n sang d\u1ea1ng s\u1ed1<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Khi nh\u1eefng s\u1ed1 kh\u00f4ng xu\u1ea5t hi\u1ec7n \u1edf \u0111\u1ea7u gi\u00e1 tr\u1ecb trong m\u1ed9t \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u1edf d\u1ea1ng v\u0103n b\u1ea3n th\u00ec c\u00e1ch d\u1ec5 nh\u1ea5t \u0111\u1ec3 lo\u1ea1i b\u1ecf ch\u00fang l\u00e0 nh\u1ea5n v\u00e0o m\u1ed9t ho\u1eb7c nhi\u1ec1u \u00f4 r\u1ed3i ch\u1ecdn \u0111i\u1ec3m c\u00f3 d\u1ea5u ch\u1ea5m than, ch\u1ecdn ti\u1ebfp Convert to Number:<\/span><\/p>\n<figure id=\"attachment_6338\" aria-describedby=\"caption-attachment-6338\" style=\"width: 307px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6338 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/00014.png\" alt=\"chuyen-sang-dinh-dang-so\" width=\"307\" height=\"225\" title=\"00014\"><figcaption id=\"caption-attachment-6338\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">chuyen-sang-dinh-dang-so<\/span><\/figcaption><\/figure>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Loai_bo_cac_so_khong_dung_dau_bang_cach_su_dung_cong_thuc\"><\/span><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Lo\u1ea1i b\u1ecf c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u0111\u1ea7u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Trong tr\u01b0\u1eddng h\u1ee3p m\u1ed9t ho\u1eb7c nhi\u1ec1u s\u1ed1 kh\u00f4ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o ph\u00eda tr\u01b0\u1edbc gi\u00e1 tr\u1ecb b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c th\u00ec b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c kh\u00e1c \u0111\u1ec3 lo\u1ea1i b\u1ecf ch\u00fang. C\u00f4ng th\u1ee9c \u0111\u1ec3 lo\u1ea1i b\u1ecf kh\u00e1 \u0111\u01a1n gi\u1ea3n:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\"><strong>=VALUE(A2)<\/strong><\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Trong \u0111\u00f3 A2 l\u00e0 \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u1edf \u0111\u1ea7u.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u01b0\u1ee3c g\u00f5 tr\u1ef1c ti\u1ebfp v\u00e0o \u00f4 (nh\u01b0 \u1edf v\u00ed d\u1ee5 tr\u01b0\u1edbc) ho\u1eb7c nh\u1eadp v\u00e0o Excel t\u1eeb m\u1ed9t s\u1ed1 ngu\u1ed3n b\u00ean ngo\u00e0i. N\u00f3i chung, n\u1ebfu b\u1ea1n mu\u1ed1n thao t\u00e1c v\u1edbi chu\u1ed7i c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u1ee9ng \u1edf \u0111\u1ea7u th\u00ec c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VALUE \u0111\u1ec3 chuy\u1ec3n v\u0103n b\u1ea3n sang s\u1ed1 v\u00e0 lo\u1ea1i b\u1ecf c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u00f3.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">B\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i hai c\u00f4ng th\u1ee9c \u1edf \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">C\u00f4ng th\u1ee9c Text \u1edf \u00f4 B2 \u0111\u1ec3 th\u00eam s\u1ed1 kh\u00f4ng v\u00e0o \u0111\u1ea7u gi\u00e1 tr\u1ecb<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> C\u00f4ng th\u1ee9c VALUE \u1edf \u00f4 C2 \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c s\u1ed1 kh\u00f4ng \u0111\u00e3 th\u00eam v\u00e0o.<\/span><\/p>\n<figure id=\"attachment_6339\" aria-describedby=\"caption-attachment-6339\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6339\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/00015.png\" alt=\"loai-bo-so-khong-bang-cong-thuc\" width=\"600\" height=\"177\" title=\"00015\"><figcaption id=\"caption-attachment-6339\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">loai-bo-so-khong-bang-cong-thuc<\/span><\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_an_cac_so_khong_trong_Excel\"><\/span><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">C\u00e1ch \u1ea9n c\u00e1c s\u1ed1 kh\u00f4ng trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n hi\u1ec3n th\u1ecb c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng trong b\u1ea3ng t\u00ednh Excel th\u00ec c\u00f3 hai l\u1ef1a ch\u1ecdn nh\u01b0 sau:<\/span><\/p>\n<ol style=\"text-align: justify\">\n<li><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">\u0110\u1ec3 \u1ea9n c\u00e1c s\u1ed1 kh\u00f4ng tr\u00ean to\u00e0n b\u1ed9 trang t\u00ednh, b\u1ea1n ch\u1ecdn File &gt; Options &gt; Advanced, k\u00e9o xu\u1ed1ng d\u01b0\u1edbi r\u1ed3i b\u1ecf ch\u1ecdn m\u1ee5c Show a zero in cells that have zero value.<\/span>\n<p><figure id=\"attachment_6340\" aria-describedby=\"caption-attachment-6340\" style=\"width: 601px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6340 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/00016.png\" alt=\"cach-an-so-khong-trong-excel\" width=\"601\" height=\"457\" title=\"00016\"><figcaption id=\"caption-attachment-6340\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">cach-an-so-khong-trong-excel<\/span><\/figcaption><\/figure>\n<\/p>\n<\/li>\n<li><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">\u0110\u1ec3 \u1ea9n c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng trong nh\u1eefng \u00f4 nh\u1ea5t \u0111\u1ecbnh, b\u1ea1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 t\u00f9y ch\u1ec9nh cho c\u00e1c \u00f4 \u0111\u00f3: #;#;;@<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif;font-size: 12pt\"> \u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y, ch\u1ecdn c\u00e1c \u00f4 b\u1ea1n mu\u1ed1n \u1ea9n s\u1ed1 kh\u00f4ng, nh\u1ea5n Ctrl + 1 \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Format Cells, ch\u1ecdn Custom trong Category, g\u00f5 m\u00e3 \u0111\u1ecbnh d\u1ea1ng \u1edf tr\u00ean v\u00e0o h\u1ed9p Type.<\/span><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi \u0111\u00e2y, c\u00f3 th\u1ec3 th\u1ea5y \u00f4 B2 c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng 0 nh\u01b0ng n\u00f3 kh\u00f4ng \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong \u00f4.<\/span><\/p>\n<figure id=\"attachment_6341\" aria-describedby=\"caption-attachment-6341\" style=\"width: 535px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6341 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/00017.png\" alt=\"an-gia-tri-khong-trong-nhung-o-nhat-dinh\" width=\"535\" height=\"537\" title=\"00017\"><figcaption id=\"caption-attachment-6341\" class=\"wp-caption-text\"><span style=\"font-size: 12pt;font-family: georgia, palatino, serif\">an-gia-tri-khong-trong-nhung-o-nhat-dinh<\/span><\/figcaption><\/figure>\n<p style=\"text-align: justify\"><span style=\"font-family: georgia, palatino, serif;font-size: 12pt\">Tr\u00ean \u0111\u00e2y l\u00e0 b\u00e0i vi\u1ebft v\u1ec1 c\u00e1ch th\u00eam, lo\u1ea1i b\u1ecf v\u00e0 \u1ea9n c\u00e1c s\u1ed1 kh\u00f4ng trong Excel. C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 theo d\u00f5i b\u00e0i vi\u1ebft.<\/span><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a> t\u1ea1i <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">H\u1ecdc Excel Online<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-40.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11430,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11429","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\/11429","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=11429"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11429\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11430"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}