{"id":12202,"date":"2022-11-25T10:54:42","date_gmt":"2022-11-25T03:54:42","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12202"},"modified":"2022-12-06T16:21:37","modified_gmt":"2022-12-06T09:21:37","slug":"cach-dinh-dang-so-dien-thoai-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/","title":{"rendered":"C\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel\u00a0d\u1ec5 th\u1ef1c hi\u1ec7n"},"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;12202&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;11&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4&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;4\\\/5 - (11 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;C\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel\u00a0d\u1ec5 th\u1ef1c hi\u1ec7n&quot;,&quot;width&quot;:&quot;113.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: 113.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            4\/5 - (11 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em><span style=\"font-weight: 400;\">Ph\u1ea7n m\u1ec1m Excel c\u00f3 l\u1ebd kh\u00f4ng c\u00f2n qu\u00e1 xa l\u1ea1 \u0111\u1ed1i v\u1edbi m\u1ed7i ng\u01b0\u1eddi ch\u00fang ta. \u0110\u1eb7c bi\u1ec7t h\u01a1n c\u1ea3 l\u00e0 v\u1edbi d\u00e2n v\u0103n ph\u00f2ng, nh\u1eefng ng\u01b0\u1eddi l\u00e0m vi\u1ec7c li\u00ean quan nhi\u1ec1u \u0111\u1ebfn s\u1ed5 s\u00e1ch, con s\u1ed1. C\u00f3 r\u1ea5t nhi\u1ec1u th\u1ee7 thu\u1eadt \u0111\u1ec3 nh\u1eadp v\u00e0 x\u1eed l\u00fd s\u1ed1 li\u1ec7u nhanh ch\u00f3ng, ch\u00ednh x\u00e1c nh\u01b0ng kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft. Trong \u0111\u00f3, <\/span><b>c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel <\/b><span style=\"font-weight: 400;\">v\u1eabn c\u00f2n l\u00e0 d\u1ea5u ch\u1ea5m h\u1ecfi \u0111\u1ed1i v\u1edbi nhi\u1ec1u ng\u01b0\u1eddi. N\u1ebfu b\u1ea1n c\u0169ng \u0111ang quan t\u00e2m \u0111\u1ebfn ch\u1ee7 \u0111\u1ec1 tr\u00ean, h\u00e3y c\u00f9ng \u0111i\u1ec3m qua nh\u1eefng th\u00f4ng tin h\u1eefu \u00edch v\u1edbi b\u00e0i vi\u1ebft sau nh\u00e9!<\/span><\/em><\/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-dinh-dang-so-dien-thoai-trong-excel\/#Nhung_van_de_thuong_gap_khi_nhap_so_dien_thoai_trong_Excel\" >Nh\u1eefng v\u1ea5n \u0111\u1ec1 th\u01b0\u1eddng g\u1eb7p khi nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel\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-dinh-dang-so-dien-thoai-trong-excel\/#Lam_the_nao_de_dinh_dang_so_dien_thoai_trong_Excel_%E2%80%93_cach_dinh_dang_so_dien_thoai_trong_excel\" >L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel? &#8211; c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel<\/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-dinh-dang-so-dien-thoai-trong-excel\/#Dinh_dang_thu_nhat\" >\u0110\u1ecbnh d\u1ea1ng th\u1ee9 nh\u1ea5t\u00a0<\/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-dinh-dang-so-dien-thoai-trong-excel\/#Dinh_dang_thu_hai_%E2%80%93_cach_dinh_dang_so_dien_thoai_trong_excel\" >\u0110\u1ecbnh d\u1ea1ng th\u1ee9 hai &#8211; c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel<\/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-dinh-dang-so-dien-thoai-trong-excel\/#Dinh_dang_thu_ba\" >\u0110\u1ecbnh d\u1ea1ng th\u1ee9 ba<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/#Dinh_dang_thu_tu_%E2%80%93_cach_dinh_dang_so_dien_thoai_trong_excel\" >\u0110\u1ecbnh d\u1ea1ng th\u1ee9 t\u01b0 &#8211; c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/#Nhung_dieu_can_luu_y_ve_thu_thuat_dinh_dang_so_dien_thoai_trong_Excel\" >Nh\u1eefng \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd v\u1ec1 th\u1ee7 thu\u1eadt \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel\u00a0<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Nhung_van_de_thuong_gap_khi_nhap_so_dien_thoai_trong_Excel\"><\/span><b>Nh\u1eefng v\u1ea5n \u0111\u1ec1 th\u01b0\u1eddng g\u1eb7p khi nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Th\u00f4ng th\u01b0\u1eddng, khi nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel, s\u1ed1 0 \u0111\u1ea7u ti\u00ean s\u1ebd b\u1ecb m\u1ea5t \u0111i v\u00ec \u0111\u1ecbnh d\u1ea1ng \u0111\u01b0\u1ee3c hi\u1ec3u trong ph\u1ea7n m\u1ec1m l\u00e0 d\u1ea1ng s\u1ed1. \u0110\u1ed1i v\u1edbi \u0111\u1ecbnh d\u1ea1ng n\u00e0y, s\u1ed1 kh\u00f4ng th\u1ec3 b\u1eaft \u0111\u1ea7u b\u1eb1ng s\u1ed1 0.\u00a0<\/span><\/p>\n<figure id=\"attachment_12214\" aria-describedby=\"caption-attachment-12214\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12214\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-nhanh-3.jpg\" alt=\"c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel\" width=\"600\" height=\"450\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-nhanh-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-nhanh-3-400x300.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12214\" class=\"wp-caption-text\">Kh\u00f4ng th\u1ec3 hi\u1ec3n th\u1ecb s\u1ed1 0 tr\u01b0\u1edbc s\u1ed1 \u0111i\u1ec7n tho\u1ea1i khi nh\u1eadp Excel theo c\u00e1ch th\u01b0\u1eddng<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, khi nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u00e0o \u00f4 b\u1ea5t k\u1ef3 trong Excel, s\u1ed1 0 \u0111\u1ea7u ti\u00ean s\u1ebd t\u1ef1 \u0111\u1ed9ng bi\u1ebfn m\u1ea5t. \u0110i\u1ec1u n\u00e0y s\u1ebd \u1ea3nh h\u01b0\u1edfng t\u1edbi t\u00ednh ch\u00ednh x\u00e1c trong qu\u00e1 tr\u00ecnh nh\u1eadp li\u1ec7u. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y tr\u1edf th\u00e0nh b\u0103n kho\u0103n c\u1ee7a r\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_dinh_dang_so_dien_thoai_trong_Excel_%E2%80%93_cach_dinh_dang_so_dien_thoai_trong_excel\"><\/span><b>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel? &#8211; c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean th\u1ef1c t\u1ebf, c\u00f3 nhi\u1ec1u <\/span><b><i>c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel<\/i><\/b> <span style=\"font-weight: 400;\">m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o v\u00e0 \u00e1p d\u1ee5ng. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 4 c\u00e1ch si\u00eau \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng m\u00e0 ch\u00fang t\u00f4i \u0111\u00e3 t\u1ed5ng h\u1ee3p. C\u1ee5 th\u1ec3 bao g\u1ed3m:<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"C\u00e1ch vi\u1ebft s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel, c\u00e1ch hi\u1ec7n s\u1ed1 0 trong Excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/XxwwoaHZ27U?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<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Dinh_dang_thu_nhat\"><\/span><b><i>\u0110\u1ecbnh d\u1ea1ng th\u1ee9 nh\u1ea5t\u00a0<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ea7u ti\u00ean, m\u1edf ph\u1ea7n m\u1ec1m Excel v\u00e0 ch\u1ecdn s\u1ed1 \u0111i\u1ec7n tho\u1ea1i m\u00e0 b\u1ea1n \u0111\u00e3 nh\u1eadp v\u00e0o \u00f4 trong Excel. V\u00e0o tab Home, ch\u1ecdn Format. Ch\u1ecdn ti\u1ebfp Format Cells n\u1eb1m \u1edf cu\u1ed1i trong danh s\u00e1ch l\u1ef1a ch\u1ecdn.<\/span><\/p>\n<figure id=\"attachment_12204\" aria-describedby=\"caption-attachment-12204\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12204 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-2.jpg\" alt=\"\" width=\"600\" height=\"605\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-2-397x400.jpg 397w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-2-150x150.jpg 150w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12204\" class=\"wp-caption-text\">Nh\u1ea5n ch\u1ecdn t\u1ea1i m\u1ee5c Format Cells \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i t\u00f9y ch\u1ec9nh<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00fac n\u00e0y, h\u1ed9p tho\u1ea1i Format Cells s\u1ebd xu\u1ea5t hi\u1ec7n v\u1edbi nh\u1eefng \u00f4 \u0111\u1ecbnh d\u1ea1ng l\u1ea7n l\u01b0\u1ee3t l\u00e0 Number, Alignment, Font, Border, Fill, Protection.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong m\u1ee5c Number, ch\u00fang ta ch\u1ecdn Custom. B\u1ea1n s\u1ebd th\u1ea5y th\u00f4ng tin hi\u1ec7n trong nh\u00f3m Type l\u00e0 General v\u00e0 kh\u00f4ng c\u00f3 s\u1eb5n \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i.\u00a0<\/span><\/p>\n<figure id=\"attachment_12208\" aria-describedby=\"caption-attachment-12208\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12208 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-6.jpg\" alt=\"\" width=\"600\" height=\"526\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-6.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-6-400x351.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12208\" class=\"wp-caption-text\">Theo m\u1eb7c \u0111\u1ecbnh s\u1ebd kh\u00f4ng c\u00f3 s\u1eb5n \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 c\u00f3 th\u1ec3 nh\u1eadp \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, ch\u00fang ta c\u1ea7n xo\u00e1 c\u00e1c s\u1ed1 ho\u1eb7c v\u0103n b\u1ea3n \u0111\u00e3 \u0111i\u1ec1n, sau \u0111\u00f3 nh\u1eadp \u0111\u1ecbnh d\u1ea1ng m\u1edbi. V\u00ed d\u1ee5, v\u1edbi s\u1ed1 \u0111i\u1ec7n tho\u1ea1i c\u1ee7a Vi\u1ec7t Nam, ch\u00fang ta th\u00eam +84 v\u00e0 sau \u0111\u00f3 l\u00e0 9 s\u1ed1 0 theo \u0111\u00fang nh\u01b0 \u0111\u1ecbnh d\u1ea1ng hi\u1ec7n nay.<\/span><\/p>\n<p style=\"text-align: justify;\"><i><span style=\"font-weight: 400;\">Nh\u1eadp \u0111\u1ecbnh d\u1ea1ng m\u1edbi v\u1edbi s\u1ed1 \u0111i\u1ec7n tho\u1ea1i c\u1ee7a Vi\u1ec7t Nam s\u1ebd th\u00eam +84<\/span><\/i><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00fac n\u00e0y, trong nh\u00f3m Type s\u1ebd \u0111\u01b0\u1ee3c th\u00eam \u0111\u1ecbnh d\u1ea1ng m\u1edbi l\u00e0 +84-000000000. B\u1ea1n ch\u1ec9 c\u1ea7n b\u1ea5m ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng n\u00e0y v\u00e0 OK l\u00e0 \u0111\u01b0\u1ee3c.<\/span><\/p>\n<figure id=\"attachment_12207\" aria-describedby=\"caption-attachment-12207\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12207\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-5.jpg\" alt=\"c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel\" width=\"600\" height=\"444\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-5.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-5-400x296.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12207\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 cho th\u1ea5y khi b\u1ea1n \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel th\u00e0nh c\u00f4ng<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Dinh_dang_thu_hai_%E2%80%93_cach_dinh_dang_so_dien_thoai_trong_excel\"><\/span><b><i>\u0110\u1ecbnh d\u1ea1ng th\u1ee9 hai &#8211; c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ch\u00fang ta c\u0169ng th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc nh\u01b0 tr\u00ean. Tuy nhi\u00ean, trong h\u1ed9p tho\u1ea1i Format Cells, nh\u00f3m Type, ch\u00fang ta s\u1ebd b\u1ed5 sung \u0111\u1ecbnh d\u1ea1ng m\u1edbi.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Thay v\u00ec ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng +84 v\u00e0 9 s\u1ed1 0 nh\u01b0 c\u00e1ch \u0111\u1ea7u ti\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 chia s\u1ed1 \u0111i\u1ec7n tho\u1ea1i th\u00e0nh 3 ph\u1ea7n \u0111\u1ec3 d\u1ec5 \u0111\u1ecdc v\u00e0 tr\u00e1nh nh\u1ea7m l\u1eabn khi nh\u1eadp li\u1ec7u h\u01a1n.<\/span><\/p>\n<figure id=\"attachment_12208\" aria-describedby=\"caption-attachment-12208\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12208 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-6.jpg\" alt=\"\" width=\"600\" height=\"526\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-6.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-6-400x351.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12208\" class=\"wp-caption-text\">C\u00f3 th\u1ec3 chia s\u1ed1 \u0111i\u1ec7n tho\u1ea1i th\u00e0nh 3 ph\u1ea7n \u0111\u1ec3 d\u1ec5 \u0111\u1ecdc v\u00e0 tr\u00e1nh nh\u1ea7m l\u1eabn h\u01a1n<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi \u0111\u1ecbnh d\u1ea1ng n\u00e0y, ch\u00fang ta nh\u1eadp +84-000-000-000. K\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb s\u1ebd l\u00e0 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u1edbi \u0111\u1ecbnh d\u1ea1ng t\u01b0\u01a1ng \u1ee9ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u00a0<\/span><\/p>\n<figure id=\"attachment_12205\" aria-describedby=\"caption-attachment-12205\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12205\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-3.jpg\" alt=\"c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel\" width=\"600\" height=\"522\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-3-400x348.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12205\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 c\u1ee7a vi\u1ec7c th\u00eam \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong m\u1ee5c Custom<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Dinh_dang_thu_ba\"><\/span><b><i>\u0110\u1ecbnh d\u1ea1ng th\u1ee9 ba<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi \u0111\u1ecbnh d\u1ea1ng n\u00e0y, ch\u00fang ta s\u1ebd \u0111i\u1ec1u ch\u1ec9nh trong nh\u00f3m Text. Tr\u01b0\u1edbc khi nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, ti\u1ebfn h\u00e0nh ch\u1ec9nh \u0111\u1ecbnh d\u1ea1ng \u00f4 b\u1eb1ng c\u00e1ch v\u00e0o Home, ch\u1ecdn Format, ch\u1ecdn ti\u1ebfp Format Cells.\u00a0<\/span><\/p>\n<figure id=\"attachment_12210\" aria-describedby=\"caption-attachment-12210\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12210\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-8.jpg\" alt=\"\" width=\"600\" height=\"416\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-8.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-8-400x277.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12210\" class=\"wp-caption-text\">\u0110\u1ed1i v\u1edbi \u0111\u1ecbnh d\u1ea1ng n\u00e0y, ch\u00fang ta s\u1ebd \u0111i\u1ec1u ch\u1ec9nh trong nh\u00f3m Text<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong tab Number, b\u1ea1n ch\u1ecdn nh\u00f3m Text r\u1ed3i nh\u1ea5p OK. Nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i ch\u00fang ta c\u1ea7n nh\u1eadp v\u00e0o c\u00e1c \u00f4 \u0111\u00e3 \u0111\u1ecbnh d\u1ea1ng.\u00a0<\/span><\/p>\n<figure id=\"attachment_12209\" aria-describedby=\"caption-attachment-12209\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12209\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-7.jpg\" alt=\"\" width=\"600\" height=\"528\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-7.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-7-400x352.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12209\" class=\"wp-caption-text\">Ch\u1ecdn text \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00fac n\u00e0y, s\u1ed1 0 \u0111\u1ea7u ti\u00ean s\u1ebd kh\u00f4ng b\u1ecb m\u1ea5t \u0111i v\u00ec \u0111\u1ecbnh d\u1ea1ng l\u00e0 v\u0103n b\u1ea3n. B\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c tr\u1ecdn v\u1eb9n s\u1ed1 \u0111i\u1ec7n tho\u1ea1i m\u00e0 kh\u00f4ng g\u00e2y c\u1ea3m gi\u00e1c nh\u1ea7m l\u1eabn n\u1eefa.<\/span><\/p>\n<figure id=\"attachment_12212\" aria-describedby=\"caption-attachment-12212\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12212\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-10.jpg\" alt=\"\" width=\"600\" height=\"388\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-10.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-10-400x259.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12212\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c sau khi thao t\u00e1c<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Dinh_dang_thu_tu_%E2%80%93_cach_dinh_dang_so_dien_thoai_trong_excel\"><\/span><b><i>\u0110\u1ecbnh d\u1ea1ng th\u1ee9 t\u01b0 &#8211; c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch \u0111\u1ecbnh d\u1ea1ng n\u00e0y l\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t v\u00ec ch\u00fang ta kh\u00f4ng c\u1ea7n ph\u1ea3i ch\u1ec9nh l\u1ea1i \u0111\u1ecbnh d\u1ea1ng trong h\u1ed9p Number.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Theo \u0111\u00f3, ban ch\u1ec9 c\u1ea7n th\u00eam d\u1ea5u &#8216; v\u00e0o tr\u01b0\u1edbc s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb s\u1ebd gi\u1ed1ng nh\u01b0 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i th\u00f4ng th\u01b0\u1eddng, t\u1ee9c l\u00e0 \u0111\u00e3 bao g\u1ed3m s\u1ed1 0 \u1edf tr\u01b0\u1edbc.<\/span><\/p>\n<figure id=\"attachment_12211\" aria-describedby=\"caption-attachment-12211\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12211\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-9.jpg\" alt=\"c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel\" width=\"600\" height=\"327\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-9.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-9-400x218.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-12211\" class=\"wp-caption-text\">Th\u00eam d\u1ea5u &#8216; tr\u01b0\u1edbc s\u1ed1 \u0111i\u1ec7n tho\u1ea1i \u0111\u1ec3 chuy\u1ec3n v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Nhung_dieu_can_luu_y_ve_thu_thuat_dinh_dang_so_dien_thoai_trong_Excel\"><\/span><b>Nh\u1eefng \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd v\u1ec1 th\u1ee7 thu\u1eadt \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 n\u00f3i, th\u1ee7 thu\u1eadt \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel kh\u00f4ng h\u1ec1 kh\u00f3. Tuy nhi\u00ean, ch\u00fang ta c\u1ea7n l\u01b0u \u00fd m\u1ed9t s\u1ed1 \u0111i\u1ec1u d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc khi \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u00e0o Excel, ch\u00fang ta c\u1ea7n ch\u1ecdn d\u1eef li\u1ec7u tr\u01b0\u1edbc. B\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i quan t\u00e2m n\u1ebfu d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o kh\u00f4ng \u0111\u00fang v\u1edbi \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i Vi\u1ec7t Nam.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed7i qu\u1ed1c gia v\u00e0 khu v\u1ef1c \u0111\u1ec1u c\u00f3 c\u00e1ch vi\u1ebft s\u1ed1 \u0111i\u1ec7n tho\u1ea1i ri\u00eang. Do \u0111\u00f3, b\u1ea1n n\u00ean tu\u00e2n theo quy lu\u1eadt c\u00e1ch vi\u1ebft s\u1ed1 \u0111i\u1ec7n tho\u1ea1i \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng ph\u00f9 h\u1ee3p. C\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch \u0111\u1ecbnh d\u1ea1ng nh\u01b0 chia s\u1ebb tr\u00ean \u0111\u00e2y cho n\u00ean b\u1ea1n c\u00f3 th\u1ec3 linh ho\u1ea1t \u00e1p d\u1ee5ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><i><span style=\"font-weight: 400;\">Tr\u00ean th\u1ef1c t\u1ebf, th\u1ee7 thu\u1eadt \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel kh\u00f4ng h\u1ec1 kh\u00f3<\/span><\/i><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t \u0111\u1eb7c \u0111i\u1ec3m c\u1ee7a s\u1ed1 \u0111i\u1ec7n tho\u1ea1i t\u1eeb c\u00e1c qu\u1ed1c gia kh\u00e1c nhau \u0111\u00f3 l\u00e0 \u0111\u1ea7u s\u1ed1 kh\u00f4ng gi\u1ed1ng nhau. \u0110\u1ed9 d\u00e0i c\u1ee7a s\u1ed1 \u0111i\u1ec7n tho\u1ea1i c\u0169ng kh\u00f4ng \u0111\u00fang. V\u00ec th\u1ebf, vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i c\u1ee7a t\u1eebng qu\u1ed1c gia c\u0169ng c\u00f3 s\u1ef1 kh\u00e1c bi\u1ec7t v\u1ec1 \u0111\u1ea7u s\u1ed1, \u0111\u1ed9 d\u00e0i.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u1ed5ng c\u1ed9ng h\u1ea7u h\u1ebft c\u00e1c s\u1ed1 \u0111i\u1ec7n tho\u1ea1i c\u1ee7a c\u00e1c qu\u1ed1c gia kh\u00e1c nhau c\u00f3 th\u1ec3 c\u00f3 c\u00e1c s\u1ed1 kh\u00e1c nhau.\u00a0Tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng b\u1ea5t k\u1ef3 \u0111\u1ecbnh d\u1ea1ng n\u00e0o cho s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, tr\u01b0\u1edbc ti\u00ean h\u00e3y ph\u00e2n lo\u1ea1i s\u1ed1 v\u1edbi \u0111\u1ed9 d\u00e0i c\u1ee7a ch\u00fang.\u00a0V\u1edbi \u0111i\u1ec1u n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 tr\u00e1nh \u0111\u01b0\u1ee3c vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng kh\u00f4ng ch\u00ednh x\u00e1c.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>C\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel <\/b><span style=\"font-weight: 400;\">v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n. V\u1edbi nh\u1eefng th\u1ee7 thu\u1eadt \u0111\u01b0\u1ee3c <a href=\"https:\/\/teky.edu.vn\/\">Teky<\/a> chia s\u1ebb tr\u00ean \u0111\u00e2y, ch\u1eafc h\u1eb3n b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i ch\u00ednh x\u00e1c v\u00e0 nhanh ch\u00f3ng nh\u1ea5t. N\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong ph\u1ea7n m\u1ec1m Excel, h\u00e3y \u00e1p d\u1ee5ng nh\u1eefng c\u00e1ch m\u00e0 Teky h\u01b0\u1edbng d\u1eabn tr\u00ean \u0111\u00e2y nh\u00e9.<\/span><\/p>\n<p style=\"text-align: justify;\">Xem th\u00eam:<\/p>\n<ul>\n<li style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/ham-noi-ky-tu-trong-excel\/\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m n\u1ed1i k\u00fd t\u1ef1 trong excel<\/a><\/li>\n<li style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-dem-co-dieu-kien-sieu-don-gian-trong-excel\/\">S\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong excel<\/a><\/li>\n<li style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-sumifs-trong-excel-sieu-tien-ich\/\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m sumifs trong Excel si\u00eau ti\u1ec7n \u00edch<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/bo-dau-cach-trong-excel\/\" target=\"_blank\" rel=\"noopener\">B\u1eadt m\u00ed ph\u01b0\u01a1ng ph\u00e1p b\u1ecf d\u1ea5u c\u00e1ch trong Excel si\u00eau nhanh<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Ph\u1ea7n m\u1ec1m Excel c\u00f3 l\u1ebd kh\u00f4ng c\u00f2n qu\u00e1 xa l\u1ea1 \u0111\u1ed1i v\u1edbi m\u1ed7i ng\u01b0\u1eddi ch\u00fang ta. \u0110\u1eb7c bi\u1ec7t h\u01a1n c\u1ea3 l\u00e0 v\u1edbi d\u00e2n v\u0103n ph\u00f2ng, nh\u1eefng ng\u01b0\u1eddi l\u00e0m vi\u1ec7c li\u00ean quan nhi\u1ec1u \u0111\u1ebfn s\u1ed5 s\u00e1ch, con s\u1ed1. C\u00f3 r\u1ea5t nhi\u1ec1u th\u1ee7 thu\u1eadt \u0111\u1ec3 nh\u1eadp v\u00e0 x\u1eed l\u00fd s\u1ed1 li\u1ec7u nhanh ch\u00f3ng, ch\u00ednh x\u00e1c nh\u01b0ng kh\u00f4ng &hellip;<\/p>\n","protected":false},"author":3,"featured_media":12204,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12202","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>H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel<\/title>\n<meta name=\"description\" content=\"Excel l\u00e0 ph\u1ea7n m\u1ec1m nh\u1eadp v\u00e0 x\u1eed l\u00fd s\u1ed1 li\u1ec7u ti\u1ec7n \u00edch. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel ch\u00ednh x\u00e1c.\" \/>\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-dinh-dang-so-dien-thoai-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel\" \/>\n<meta property=\"og:description\" content=\"Excel l\u00e0 ph\u1ea7n m\u1ec1m nh\u1eadp v\u00e0 x\u1eed l\u00fd s\u1ed1 li\u1ec7u ti\u1ec7n \u00edch. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel ch\u00ednh x\u00e1c.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-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-11-25T03:54:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-06T09:21:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"605\" \/>\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=\"8 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-dinh-dang-so-dien-thoai-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel\u00a0d\u1ec5 th\u1ef1c hi\u1ec7n\",\"datePublished\":\"2022-11-25T03:54:42+00:00\",\"dateModified\":\"2022-12-06T09:21:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/\"},\"wordCount\":1894,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-2.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-2.jpg\",\"datePublished\":\"2022-11-25T03:54:42+00:00\",\"dateModified\":\"2022-12-06T09:21:37+00:00\",\"description\":\"Excel l\u00e0 ph\u1ea7n m\u1ec1m nh\u1eadp v\u00e0 x\u1eed l\u00fd s\u1ed1 li\u1ec7u ti\u1ec7n \u00edch. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel ch\u00ednh x\u00e1c.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-2.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-2.jpg\",\"width\":600,\"height\":605,\"caption\":\"Kh\u00f4ng th\u1ec3 hi\u1ec3n th\u1ecb s\u1ed1 0 tr\u01b0\u1edbc s\u1ed1 \u0111i\u1ec7n tho\u1ea1i khi nh\u1eadp Excel theo c\u00e1ch th\u01b0\u1eddng\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-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\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel\u00a0d\u1ec5 th\u1ef1c hi\u1ec7n\"}]},{\"@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":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel","description":"Excel l\u00e0 ph\u1ea7n m\u1ec1m nh\u1eadp v\u00e0 x\u1eed l\u00fd s\u1ed1 li\u1ec7u ti\u1ec7n \u00edch. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel ch\u00ednh x\u00e1c.","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-dinh-dang-so-dien-thoai-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel","og_description":"Excel l\u00e0 ph\u1ea7n m\u1ec1m nh\u1eadp v\u00e0 x\u1eed l\u00fd s\u1ed1 li\u1ec7u ti\u1ec7n \u00edch. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel ch\u00ednh x\u00e1c.","og_url":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-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-11-25T03:54:42+00:00","article_modified_time":"2022-12-06T09:21:37+00:00","og_image":[{"width":600,"height":605,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-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":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel\u00a0d\u1ec5 th\u1ef1c hi\u1ec7n","datePublished":"2022-11-25T03:54:42+00:00","dateModified":"2022-12-06T09:21:37+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/"},"wordCount":1894,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-2.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/","name":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-2.jpg","datePublished":"2022-11-25T03:54:42+00:00","dateModified":"2022-12-06T09:21:37+00:00","description":"Excel l\u00e0 ph\u1ea7n m\u1ec1m nh\u1eadp v\u00e0 x\u1eed l\u00fd s\u1ed1 li\u1ec7u ti\u1ec7n \u00edch. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft c\u00e1ch \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel ch\u00ednh x\u00e1c.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-2.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-dinh-dang-so-dien-thoai-trong-excel-2.jpg","width":600,"height":605,"caption":"Kh\u00f4ng th\u1ec3 hi\u1ec3n th\u1ecb s\u1ed1 0 tr\u01b0\u1edbc s\u1ed1 \u0111i\u1ec7n tho\u1ea1i khi nh\u1eadp Excel theo c\u00e1ch th\u01b0\u1eddng"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-dinh-dang-so-dien-thoai-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\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong excel\u00a0d\u1ec5 th\u1ef1c hi\u1ec7n"}]},{"@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\/12202","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=12202"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12202\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12204"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}