{"id":10739,"date":"2022-10-03T22:06:52","date_gmt":"2022-10-03T15:06:52","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=10739"},"modified":"2022-11-03T11:30:09","modified_gmt":"2022-11-03T04:30:09","slug":"cach-danh-so-0-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/","title":{"rendered":"C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n d\u00e0nh cho b\u1ea1n"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;10739&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;4&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (4 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n d\u00e0nh cho b\u1ea1n&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (4 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p><i><span style=\"font-weight: 400;\">Khi thao t\u00e1c nh\u1eadp li\u1ec7u tr\u00ean excel, ch\u1eafc h\u1eb3n \u0111\u00e3 nhi\u1ec1u l\u1ea7n b\u1ea1n g\u1eb7p ph\u1ea3i t\u00ecnh tr\u1ea1ng m\u1ea5t s\u1ed1 0 sau khi nh\u1eadp. \u0110\u1eb7c bi\u1ec7t l\u00e0 c\u00e1c d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn s\u1ed1 \u0111i\u1ec7n tho\u1ea1i ho\u1eb7c ng\u00e0y th\u00e1ng. \u0110i\u1ec1u n\u00e0y g\u00e2y ra nh\u1eefng b\u1ea5t ti\u1ec7n c\u1ef1c k\u1ef3 kh\u00f3 ch\u1ecbu cho nh\u1eefng ai l\u1ea7n \u0111\u1ea7u l\u00e0m quen v\u1edbi Excel. \u0110i\u1ec1u n\u00e0y b\u1eaft ngu\u1ed3n t\u1eeb m\u1ed9t l\u00fd do r\u1ea5t \u0111\u01a1n gi\u1ea3n m\u00e0 ch\u1eafc ch\u1eafn nhi\u1ec1u ng\u01b0\u1eddi trong ch\u00fang ta kh\u00f4ng ng\u1edd t\u1edbi. Ch\u00ednh v\u00ec v\u1eady, c\u00e1ch gi\u1ea3i quy\u1ebft c\u0169ng v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o ngay 03 <\/span><\/i><b><i>c\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel <\/i><\/b><i><span style=\"font-weight: 400;\">ngay sau \u0111\u00e2y \u0111\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y nh\u00e9!\u00a0<\/span><\/i><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#Tai_sao_khong_the_nhap_so_0_theo_cach_thong_thuong\" >T\u1ea1i sao kh\u00f4ng th\u1ec3 nh\u1eadp s\u1ed1 0 theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng?\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#03_Cach_danh_so_0_trong_Excel_don_gian_ban_nen_biet\" >03 C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel \u0111\u01a1n gi\u1ea3n b\u1ea1n n\u00ean bi\u1ebft\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#Su_dung_ky_hieu_dau_nhay_%E2%80%98\" >S\u1eed d\u1ee5ng k\u00fd hi\u1ec7u d\u1ea5u nh\u00e1y [\u2018]<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#Dinh_dang_day_so_theo_dang_van_ban\" >\u0110\u1ecbnh d\u1ea1ng d\u00e3y s\u1ed1 theo d\u1ea1ng v\u0103n b\u1ea3n\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#Cach_danh_so_0_dang_truoc_trong_Excel_bang_ham_Concatenate\" >C\u00e1ch \u0111\u00e1nh s\u1ed1 0 \u0111\u1eb1ng tr\u01b0\u1edbc trong Excel b\u1eb1ng h\u00e0m Concatenate<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#Ket_luan_chung\" >K\u1ebft lu\u1eadn chung\u00a0<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tai_sao_khong_the_nhap_so_0_theo_cach_thong_thuong\"><\/span><b>T\u1ea1i sao kh\u00f4ng th\u1ec3 nh\u1eadp s\u1ed1 0 theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng?\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Khi b\u1ea1n nh\u1eadp c\u00e1c con s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 9, m\u1ecdi th\u1ee9 \u0111\u1ec1u r\u1ea5t su\u00f4n s\u1ebb v\u00e0 b\u00ecnh th\u01b0\u1eddng. Tuy nhi\u00ean, khi nh\u1eadp m\u1ed9t d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn s\u1ed1 0, th\u01b0\u1eddng th\u00ec s\u1ed1 0 s\u1ebd t\u1ef1 nhi\u00ean bi\u1ebfn m\u1ea5t. \u0110\u1eb7c bi\u1ec7t l\u00e0 c\u00e1c d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn s\u1ed1 \u0111i\u1ec7n tho\u1ea1i ho\u1eb7c ng\u00e0y th\u00e1ng. Ho\u1eb7c l\u00e0 c\u00e1c lo\u1ea1i s\u1ed1 ch\u1ee9ng minh, s\u1ed1 th\u1ebb ng\u00e2n h\u00e0ng, th\u1ebb sinh vi\u00ean\u2026 V\u1eady nguy\u00ean nh\u00e2n l\u00e0 do \u0111\u00e2u? R\u1ea5t \u0111\u01a1n gi\u1ea3n, b\u1eddi v\u00ec Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 l\u1eadp tr\u00ecnh.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Do \u0111\u00f3, n\u00f3 nh\u1eadn di\u1ec7n c\u00e1c con s\u1ed1 m\u1ed9t c\u00e1ch m\u00e1y m\u00f3c v\u00e0 c\u00f3 ph\u1ea7n phi\u1ebfn di\u1ec7n. Khi nh\u1eadp m\u1ed9t d\u00e3y s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, v\u00ed d\u1ee5: 012345678, Excel s\u1ebd nh\u1eadn di\u1ec7n \u0111\u00e2y l\u00e0 m\u1ed9t d\u00e3y s\u1ed1 t\u1ef1 nhi\u00ean. V\u00e0 t\u1ea5t nhi\u00ean, nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, d\u00e3y s\u1ed1 t\u1ef1 nhi\u00ean kh\u00f4ng b\u1eaft \u0111\u1ea7u v\u1edbi s\u1ed1 0. Ho\u1eb7c s\u1ed1 0 kh\u00f4ng c\u00f3 \u00fd ngh\u0129a khi n\u1eb1m \u1edf \u0111\u1ea7u d\u00e3y s\u1ed1. Do \u0111\u00f3, thu\u1eadt to\u00e1n Excel s\u1ebd x\u1eed l\u00fd nhanh b\u1eb1ng c\u00e1ch \u1ea9n s\u1ed1 0. Ch\u00ednh v\u00ec v\u1eady, n\u00f3 c\u0169ng g\u00e2y ra m\u1ed9t s\u1ed1 b\u1ea5t ti\u1ec7n cho ng\u01b0\u1eddi nh\u1eadp li\u1ec7u Excel. V\u00e0 sau \u0111\u00e2y s\u1ebd l\u00e0<\/span><b> 03 c\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel<\/b><span style=\"font-weight: 400;\"> r\u1ea5t \u0111\u01a1n gi\u1ea3n.\u00a0<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"C\u00c1CH TH\u00caM S\u1ed0 KH\u00d4NG V\u00c0O TR\u01af\u1edaC S\u1ed0 \u0110I\u1ec6N THO\u1ea0I TRONG EXCEL\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/c9jc3M2m0so?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h2><span class=\"ez-toc-section\" id=\"03_Cach_danh_so_0_trong_Excel_don_gian_ban_nen_biet\"><\/span><b>03 C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel \u0111\u01a1n gi\u1ea3n b\u1ea1n n\u00ean bi\u1ebft\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">K\u1ef9 n\u0103ng s\u1eed d\u1ee5ng Excel \u0111ang ng\u00e0y c\u00e0ng ph\u1ed5 bi\u1ebfn. Do \u0111\u00f3, nh\u1eefng k\u1ef9 thu\u1eadt \u0111\u01a1n gi\u1ea3n nh\u01b0 nh\u1eadp li\u1ec7u c\u00e1c b\u1ea1n c\u1ea7n ph\u1ea3i th\u00e0nh th\u1ea1o. V\u00e0 \u0111\u1ed1i v\u1edbi th\u1eafc m\u1eafc n\u00e0y, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o ngay 03 c\u00e1ch \u0111\u01a1n gi\u1ea3n sau \u0111\u00e2y:\u00a0<\/span><\/p>\n<ul>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ky_hieu_dau_nhay_%E2%80%98\"><\/span><b><i>S\u1eed d\u1ee5ng k\u00fd hi\u1ec7u d\u1ea5u nh\u00e1y [\u2018]<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 <\/span><b>c\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel<\/b><span style=\"font-weight: 400;\"> \u0111\u01a1n gi\u1ea3n nh\u1ea5t d\u00e0nh cho c\u00e1c d\u1ea1ng d\u00e3y s\u1ed1 th\u00f4ng th\u01b0\u1eddng. Ch\u1eb3ng h\u1ea1n nh\u01b0 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i. \u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1ch n\u00e0y, c\u00e1c b\u1ea1n ch\u1ec9 c\u1ea7n thao t\u00e1c r\u1ea5t \u0111\u01a1n gi\u1ea3n. \u1ede \u0111\u1ea7u m\u1ed7i d\u00e3y s\u1ed1, c\u00e1c b\u1ea1n ch\u1ec9 c\u1ea7n th\u00eam m\u1ed9t d\u1ea5u nh\u00e1y tr\u01b0\u1edbc s\u1ed1 0. C\u1ee5 th\u1ec3 nh\u01b0 trong h\u00ecnh m\u00f4 t\u1ea3 d\u01b0\u1edbi \u0111\u00e2y. \u1ede c\u1ed9t B, l\u00e0 c\u00e1c d\u00e3y s\u1ed1 \u0111i\u1ec7n tho\u1ea1i b\u1eaft \u0111\u1ea7u v\u1edbi s\u1ed1 0 nh\u01b0ng kh\u00f4ng c\u00f3 d\u1ea5u nh\u00e1y. Sang c\u1ed9t C, c\u00e1c d\u00e3y s\u1ed1 \u0111\u00e3 c\u00f3 d\u1ea5u nh\u00e1y ph\u00eda tr\u01b0\u1edbc, do \u0111\u00f3, s\u1ed1 0 s\u1ebd kh\u00f4ng b\u1ecb m\u1ea5t \u0111i. Tuy nhi\u00ean, c\u00e1ch n\u00e0y c\u00f3 m\u1ed9t h\u1ea1n ch\u1ebf l\u1edbn \u0111\u00f3 l\u00e0 r\u1ea5t th\u1ee7 c\u00f4ng. N\u1ebfu ph\u1ea3i nh\u1eadp m\u1ed9t l\u01b0\u1ee3ng l\u1edbn c\u00e1c d\u1eef li\u1ec7u s\u1ed1 th\u00ec nh\u1eadp th\u00eam d\u1ea5u nh\u00e1y cho t\u1eebng d\u00e3y nh\u01b0 v\u1eady s\u1ebd r\u1ea5t m\u1ea5t th\u1eddi gian.\u00a0<\/span><\/p>\n<figure id=\"attachment_10741\" aria-describedby=\"caption-attachment-10741\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10741\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-1-1-400x185.jpg\" alt=\"cach-danh-so-0-trong-excel-1\" width=\"400\" height=\"185\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-1-1-400x185.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-1-1.jpg 545w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10741\" class=\"wp-caption-text\">Khi c\u00f3 nh\u1ea5p nh\u00e1y, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp \u0111\u01b0\u1ee3c s\u1ed1 0 m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng<\/figcaption><\/figure>\n<ul>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Dinh_dang_day_so_theo_dang_van_ban\"><\/span><b><i>\u0110\u1ecbnh d\u1ea1ng d\u00e3y s\u1ed1 theo d\u1ea1ng v\u0103n b\u1ea3n\u00a0<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">M\u1ed9t c\u00e1ch kh\u00f4ng k\u00e9m ph\u1ea7n \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh h\u01a1n \u0111\u00f3 l\u00e0 c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng Text. \u0110\u00e2y l\u00e0 \u0111\u1ecbnh d\u1ea1ng nh\u1eadp li\u1ec7u n\u1ed9i dung cho \u00f4 t\u00ednh. \u0110\u1ea7u ti\u00ean, c\u00e1c \u0111\u00fap chu\u1ed9t v\u00e0o \u00f4 t\u00ednh, sau \u0111\u00f3 nh\u1ea5n chu\u1ed9t ph\u1ea3i, ch\u1ecdn v\u00e0o Format Cell (Nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y).\u00a0<\/span><\/p>\n<figure id=\"attachment_10742\" aria-describedby=\"caption-attachment-10742\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10742\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-2-400x265.jpg\" alt=\"cach-danh-so-0-trong-excel-2\" width=\"400\" height=\"265\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-2-400x265.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-2.jpg 745w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10742\" class=\"wp-caption-text\">L\u1ef1a ch\u1ecdn Format Cell \u0111\u1ec3 b\u1eaft \u0111\u1ea7u \u0111\u1ecbnh d\u1ea1ng cho \u00f4 t\u00ednh c\u1ee7a b\u1ea1n<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Ti\u1ebfp t\u1ee5c, b\u1ea1n ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng Text trong thanh Format Cell n\u00e0y. V\u1eady l\u00e0 sau khi ch\u1ecdn, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng nh\u1eadp d\u00e3y s\u1ed1 b\u1eaft \u0111\u1ea7u b\u1eb1ng s\u1ed1 0 m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. \u0110\u1ecbnh d\u1ea1ng Text s\u1ebd l\u00e0 \u0111\u1ecbnh d\u1ea1ng cho v\u0103n b\u1ea3n, do \u0111\u00f3, c\u00e1c thu\u1eadt to\u00e1n nh\u1eadn di\u1ec7n s\u1ed1 c\u1ee7a Excel s\u1ebd b\u1ecb v\u00f4 hi\u1ec7u. Nh\u1edd v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp li\u1ec7u d\u1ec5 d\u00e0ng m\u00e0 kh\u00f4ng c\u1ea7n d\u00f9ng d\u1ea5u nh\u00e1y cho t\u1eebng d\u00e3y s\u1ed1.\u00a0<\/span><\/p>\n<figure id=\"attachment_10743\" aria-describedby=\"caption-attachment-10743\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10743\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-3-400x218.jpg\" alt=\"cach-danh-so-0-trong-excel-3\" width=\"400\" height=\"218\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-3-400x218.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-3.jpg 737w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10743\" class=\"wp-caption-text\">L\u1ef1a ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng Text \u0111\u1ec3 nh\u1eadp s\u1ed1 0 \u1edf \u0111\u1ea7u d\u00e3y s\u1ed1<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Ho\u1eb7c, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng l\u1ef1a ch\u1ecdn tr\u00ean thanh l\u00e0m vi\u1ec7c. B\u1eb1ng c\u00e1ch ch\u1ecdn v\u00e0o Home. Nh\u00ecn \u1edf g\u00f3c gi\u1eefa h\u01b0\u1edbng v\u1ec1 b\u00ean ph\u1ea3i, c\u00e1c b\u1ea1n s\u1ebd th\u1ea5y m\u1ed9t thanh \u0111\u1ecbnh d\u1ea1ng.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u1ecdn v\u00e0o c\u1ed9t t\u00ednh ho\u1eb7c \u00f4 t\u00ednh, sau \u0111\u00f3 di chuy\u1ec3n chu\u1ed9t l\u00ean thanh l\u00e0m vi\u1ec7c v\u00e0 l\u1ef1a ch\u1ecdn \u0111\u1ed5i th\u00e0nh Text l\u00e0 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp li\u1ec7u c\u00f3 s\u1ed1 0 \u0111\u0103ng tr\u01b0\u1eddng m\u1ed9t c\u00e1ch b\u00ecnh th\u01b0\u1eddng. Trong tr\u01b0\u1eddng h\u1ee3p c\u1ea7n s\u1eed d\u1ee5ng c\u00e1c \u0111\u1ecbnh d\u1ea1ng s\u1ed1 li\u1ec7u kh\u00e1c nh\u01b0 s\u1ed1 t\u1ef1 nhi\u00ean hay th\u1eadp ph\u00e2n, c\u00e1c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ch\u1ecdn v\u00e0o \u0111\u00e2y \u0111\u1ec3 thay \u0111\u1ed5i theo nhu c\u1ea7u s\u1eed d\u1ee5ng.\u00a0<\/span><\/p>\n<figure id=\"attachment_10744\" aria-describedby=\"caption-attachment-10744\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10744\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-4-400x269.jpg\" alt=\"cach-danh-so-0-trong-excel-4\" width=\"400\" height=\"269\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-4-400x269.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-4-768x516.jpg 768w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-4-272x182.jpg 272w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-4.jpg 967w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10744\" class=\"wp-caption-text\">C\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng Text ngay tr\u00ean thanh l\u00e0m vi\u1ec7c m\u1ee5c Home<\/figcaption><\/figure>\n<ul>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cach_danh_so_0_dang_truoc_trong_Excel_bang_ham_Concatenate\"><\/span><b><i>C\u00e1ch \u0111\u00e1nh s\u1ed1 0 \u0111\u1eb1ng tr\u01b0\u1edbc trong Excel b\u1eb1ng h\u00e0m Concatenate<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">\u0110\u00f4i khi d\u00e3y s\u1ed1 c\u1ee7a b\u1ea1n kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u00e0 b\u1eaft \u0111\u1ea7u b\u1eb1ng s\u1ed1 0. Thay v\u00e0o \u0111\u00f3 l\u00e0 r\u1ea5t nhi\u1ec1u c\u00e1c lo\u1ea1i s\u1ed1 li\u1ec7u \u0111\u1ecbnh danh b\u1eaft \u0111\u1ea7u b\u1eb1ng \u201c000\u2026\u201d. C\u0169ng gi\u1ed1ng nh\u01b0 tr\u00ean, vi\u1ec7c b\u1eaft \u0111\u1ea7u b\u1eb1ng nhi\u1ec1u s\u1ed1 000 c\u0169ng khi\u1ebfn Excel d\u00e3y s\u1ed1 c\u1ee7a b\u1ea1n l\u00e0 s\u1ed1 t\u1ef1 nhi\u00ean c\u00f3 gi\u00e1 tr\u1ecb t\u1eeb s\u1ed1 l\u1edbn h\u01a1n 0. C\u00e1c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng \u00f4 t\u00ednh Text cho m\u1ee5c \u0111\u00edch n\u00e0y.\u00a0 <\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u00e2y s\u1ebd l\u00e0 c\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel ti\u1ec7n l\u1ee3i nh\u1ea5t m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng. B\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m Concatenate cho c\u00e1ch n\u00e0y. H\u00e0m n\u00e0y l\u00e0 h\u00e0m gh\u00e9p n\u1ed1i k\u00fd t\u1ef1. Do \u0111\u00f3, ch\u00fang ta s\u1ebd gh\u00e9p k\u00fd t\u1ef1 s\u1ed1 0 l\u00ean \u0111\u1ea7u cho m\u1ed7i d\u00e3y s\u1ed1. C\u00e1ch n\u00e0y \u00e1p d\u1ee5ng cho c\u00e1c tr\u01b0\u1eddng h\u1ee3p l\u01b0\u1ee3ng d\u1eef li\u1ec7u x\u1eed l\u00fd l\u00e0 l\u1edbn. C\u00e1c b\u1ea1n ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng h\u00e0m v\u1edbi m\u1ed9t \u00f4 t\u00ednh, sau \u0111\u00f3 d\u00f9ng chu\u1ed9t k\u00e9o th\u1ea3 cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i. V\u1eady l\u00e0 \u0111\u00e3 c\u00f3 c\u00e1c c\u1ed9t s\u1ed1 b\u1eaft \u0111\u1ea7u b\u1eb1ng s\u1ed1 0 v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n. L\u01b0u \u00fd, c\u00e1c b\u1ea1n c\u1ea7n tr\u1ea3 \u0111\u1ecbnh d\u1ea1ng v\u1ec1 \u201cNumber\u201d thay v\u00ec Text nh\u01b0 \u1edf c\u00e1ch s\u1ed1 2 nh\u00e9.\u00a0<\/span><\/p>\n<figure id=\"attachment_10745\" aria-describedby=\"caption-attachment-10745\" style=\"width: 400px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-10745\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-5-400x198.jpg\" alt=\"cach-danh-so-0-trong-excel-5\" width=\"400\" height=\"198\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-5-400x198.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-5-768x381.jpg 768w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-5.jpg 898w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><figcaption id=\"caption-attachment-10745\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m Concatenate r\u1ea5t nhanh ch\u00f3ng<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan_chung\"><\/span><b>K\u1ebft lu\u1eadn chung<\/b><span style=\"font-weight: 400;\">\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">V\u00e0 tr\u00ean \u0111\u00e2y l\u00e0 3 c\u00e1ch \u0111\u00e1nh s\u1ed1 trong Excel m\u00e0 kh\u00f4ng l\u00e0m m\u1ea5t s\u1ed1 0 \u0111\u1ee9ng \u1edf \u0111\u1ea7u d\u00e3y s\u1ed1. T\u00f9y thu\u1ed9c v\u00e0o nhu c\u1ea7u s\u1eed d\u1ee5ng m\u00e0 m\u1ed7i c\u00e1ch s\u1ebd c\u00f3 t\u00ednh \u1ee9ng d\u1ee5ng kh\u00e1c nhau. N\u1ebfu nh\u01b0 c\u00e1ch 1 \u0111em \u0111\u1ebfn s\u1ef1 ti\u1ec7n l\u1ee3i nhanh ch\u00f3ng, th\u00edch h\u1ee3p v\u1edbi c\u00e1c d\u1ea1ng nh\u1eadp li\u1ec7u ng\u1eafn. Th\u00ec c\u00e1ch 3 l\u1ea1i ph\u00f9 h\u1ee3p v\u1edbi c\u00e1c b\u1ea3ng t\u00ednh c\u00f3 d\u1eef li\u1ec7u d\u00e0y \u0111\u1eb7c. C\u00e1ch 2 c\u00f3 v\u1ebb trung l\u1eadp h\u01a1n v\u00e0 c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng trong m\u1ed9t s\u1ed1 c\u1ea7n nh\u1eadp d\u1eef li\u1ec7u \u0111\u1ed3ng nh\u1ea5t, nhanh h\u01a1n. \u0110\u00e2y l\u00e0 m\u1ed9t k\u1ef9 thu\u1eadt nh\u1eadp li\u1ec7u \u0111\u01a1n gi\u1ea3n m\u00e0 c\u00e1c b\u1ea1n n\u00ean l\u01b0u \u00fd c\u0169ng nh\u01b0 l\u00e0 ghi nh\u1edb. Ch\u00fang s\u1ebd gi\u00fap qu\u00e1 tr\u00ecnh nh\u1eadp li\u1ec7u c\u1ee7a b\u1ea1n tr\u1edf n\u00ean nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng h\u01a1n.\u00a0<\/span><\/p>\n<p><i><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, ch\u00fang ta \u0111\u00e3 t\u00ecm hi\u1ec3u v\u1ec1 3<\/span><\/i><b><i> c\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel <\/i><\/b><i><span style=\"font-weight: 400;\">chi ti\u1ebft v\u00e0 \u0111\u01a1n gi\u1ea3n. D\u00e0nh cho nh\u1eefng ai v\u1eeba m\u1edbi l\u00e0m quen v\u1edbi Excel th\u00ec h\u01b0\u1edbng d\u1eabn tr\u00ean \u0111\u00e2y s\u1ebd v\u00f4 c\u00f9ng b\u1ed5 \u00edch ph\u1ea3i kh\u00f4 n\u00e0o? N\u1ebfu c\u00f3 b\u1ea5t c\u1ee9 th\u1eafc m\u1eafc g\u00ec v\u1ec1 Excel, h\u00e3y tham kh\u1ea3o ngay t\u1ea1i <\/span><\/i><a href=\"https:\/\/teky.edu.vn\/\"><i><span style=\"font-weight: 400;\">https:\/\/teky.edu.vn\/<\/span><\/i><\/a><i><span style=\"font-weight: 400;\"> c\u1ee7a ch\u00fang t\u00f4i. Nh\u1eefng ki\u1ebfn th\u1ee9c nhanh v\u00e0 hay v\u1ec1 Excel lu\u00f4n s\u1eb5n s\u00e0ng d\u00e0nh cho b\u1ea1n!<\/span><\/i><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Khi thao t\u00e1c nh\u1eadp li\u1ec7u tr\u00ean excel, ch\u1eafc h\u1eb3n \u0111\u00e3 nhi\u1ec1u l\u1ea7n b\u1ea1n g\u1eb7p ph\u1ea3i t\u00ecnh tr\u1ea1ng m\u1ea5t s\u1ed1 0 sau khi nh\u1eadp. \u0110\u1eb7c bi\u1ec7t l\u00e0 c\u00e1c d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn s\u1ed1 \u0111i\u1ec7n tho\u1ea1i ho\u1eb7c ng\u00e0y th\u00e1ng. \u0110i\u1ec1u n\u00e0y g\u00e2y ra nh\u1eefng b\u1ea5t ti\u1ec7n c\u1ef1c k\u1ef3 kh\u00f3 ch\u1ecbu cho nh\u1eefng ai l\u1ea7n \u0111\u1ea7u l\u00e0m &hellip;<\/p>\n","protected":false},"author":3,"featured_media":10742,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-10739","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>03 C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n d\u00e0nh cho b\u1ea1n<\/title>\n<meta name=\"description\" content=\"03 C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft ngay t\u00ecnh tr\u1ea1ng nh\u1eadp s\u1ed1 0 m\u00e0 \u00f4 \u0111\u1ecba ch\u1ec9 kh\u00f4ng hi\u1ec3n th\u1ecb. Tham kh\u1ea3o ngay nh\u00e9\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"03 C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n d\u00e0nh cho b\u1ea1n\" \/>\n<meta property=\"og:description\" content=\"03 C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft ngay t\u00ecnh tr\u1ea1ng nh\u1eadp s\u1ed1 0 m\u00e0 \u00f4 \u0111\u1ecba ch\u1ec9 kh\u00f4ng hi\u1ec3n th\u1ecb. Tham kh\u1ea3o ngay nh\u00e9\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-03T15:06:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-03T04:30:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"745\" \/>\n\t<meta property=\"og:image:height\" content=\"494\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n d\u00e0nh cho b\u1ea1n\",\"datePublished\":\"2022-10-03T15:06:52+00:00\",\"dateModified\":\"2022-11-03T04:30:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/\"},\"wordCount\":1904,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-2.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/\",\"name\":\"03 C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n d\u00e0nh cho b\u1ea1n\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-2.jpg\",\"datePublished\":\"2022-10-03T15:06:52+00:00\",\"dateModified\":\"2022-11-03T04:30:09+00:00\",\"description\":\"03 C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft ngay t\u00ecnh tr\u1ea1ng nh\u1eadp s\u1ed1 0 m\u00e0 \u00f4 \u0111\u1ecba ch\u1ec9 kh\u00f4ng hi\u1ec3n th\u1ecb. Tham kh\u1ea3o ngay nh\u00e9\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-2.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-2.jpg\",\"width\":745,\"height\":494,\"caption\":\"L\u1ef1a ch\u1ecdn Format Cell \u0111\u1ec3 b\u1eaft \u0111\u1ea7u \u0111\u1ecbnh d\u1ea1ng cho \u00f4 t\u00ednh c\u1ee7a b\u1ea1n\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n d\u00e0nh cho b\u1ea1n\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"03 C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n d\u00e0nh cho b\u1ea1n","description":"03 C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft ngay t\u00ecnh tr\u1ea1ng nh\u1eadp s\u1ed1 0 m\u00e0 \u00f4 \u0111\u1ecba ch\u1ec9 kh\u00f4ng hi\u1ec3n th\u1ecb. Tham kh\u1ea3o ngay nh\u00e9","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"03 C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n d\u00e0nh cho b\u1ea1n","og_description":"03 C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft ngay t\u00ecnh tr\u1ea1ng nh\u1eadp s\u1ed1 0 m\u00e0 \u00f4 \u0111\u1ecba ch\u1ec9 kh\u00f4ng hi\u1ec3n th\u1ecb. Tham kh\u1ea3o ngay nh\u00e9","og_url":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-10-03T15:06:52+00:00","article_modified_time":"2022-11-03T04:30:09+00:00","og_image":[{"width":745,"height":494,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-2.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n d\u00e0nh cho b\u1ea1n","datePublished":"2022-10-03T15:06:52+00:00","dateModified":"2022-11-03T04:30:09+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/"},"wordCount":1904,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-2.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/","name":"03 C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n d\u00e0nh cho b\u1ea1n","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-2.jpg","datePublished":"2022-10-03T15:06:52+00:00","dateModified":"2022-11-03T04:30:09+00:00","description":"03 C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft ngay t\u00ecnh tr\u1ea1ng nh\u1eadp s\u1ed1 0 m\u00e0 \u00f4 \u0111\u1ecba ch\u1ec9 kh\u00f4ng hi\u1ec3n th\u1ecb. Tham kh\u1ea3o ngay nh\u00e9","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-2.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-danh-so-0-trong-excel-2.jpg","width":745,"height":494,"caption":"L\u1ef1a ch\u1ecdn Format Cell \u0111\u1ec3 b\u1eaft \u0111\u1ea7u \u0111\u1ecbnh d\u1ea1ng cho \u00f4 t\u00ednh c\u1ee7a b\u1ea1n"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-danh-so-0-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel r\u1ea5t \u0111\u01a1n gi\u1ea3n d\u00e0nh cho b\u1ea1n"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10739","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=10739"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/10739\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/10742"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=10739"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=10739"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=10739"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}