{"id":475,"date":"2020-07-17T15:14:06","date_gmt":"2020-07-17T08:14:06","guid":{"rendered":"https:\/\/hoctin.vn\/?p=475"},"modified":"2020-12-24T16:20:07","modified_gmt":"2020-12-24T09:20:07","slug":"cach-them-so-0-vao-so-dien-thoai-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/cach-them-so-0-vao-so-dien-thoai-trong-excel\/","title":{"rendered":"C\u00e1ch Th\u00eam S\u1ed1 0 V\u00e0o S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Trong Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"475\" class=\"elementor elementor-475\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ff14553 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ff14553\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-96a1c80\" data-id=\"96a1c80\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6ffa300 elementor-widget elementor-widget-text-editor\" data-id=\"6ffa300\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Khi nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u00e0o Excel, nhi\u1ec1u l\u00fac b\u1ea1n g\u1eb7p l\u1ed7i m\u1ea5t s\u1ed1 0 \u1edf \u0111\u1ea7u \u00f4 trong Excel.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"color: #000000; font-family: Arial; font-size: 14.6667px; white-space: pre-wrap;\">B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch th\u00eam s\u1ed1 0 v\u00e0o s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel t\u1eeb c\u00e1ch th\u1ee7 c\u00f4ng \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn c\u00e1ch nhanh nh\u1ea5t v\u00e0 t\u1ef1 \u0111\u1ed9ng nh\u1ea5t.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\">\u00a0<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d395dd5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d395dd5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-af773f9\" data-id=\"af773f9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-eede179 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"eede179\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;bullets&quot;,&quot;icon&quot;:{&quot;value&quot;:&quot;&quot;,&quot;library&quot;:&quot;&quot;},&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h4 class=\"elementor-toc__header-title\">M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\"><i class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\"><i class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-loading eicon-animation-spin\" aria-hidden=\"true\"><\/i>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c2ee377 elementor-widget elementor-widget-text-editor\" data-id=\"c2ee377\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"color: #000000; font-family: Arial; font-size: 14.6667px; text-align: justify; white-space: pre-wrap;\">L\u1ed7i kh\u00f4ng hi\u1ec7n s\u1ed1 0 trong Excel th\u01b0\u1eddng g\u1eb7p nh\u01b0 sau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-67db513 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"67db513\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b97d4d6\" data-id=\"b97d4d6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2fedefe elementor-widget elementor-widget-image\" data-id=\"2fedefe\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Mat_so_0_trong_excel.png\" title=\"Mat_so_0_trong_excel\" alt=\"L\u1ed7i kh\u00f4ng hi\u1ec7n s\u1ed1 0 m\u1ea5t s\u1ed1 0 trong excel th\u01b0\u1eddng g\u1eb7p\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7da5e74 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7da5e74\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-587d112\" data-id=\"587d112\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f23f492 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f23f492\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-963aac6\" data-id=\"963aac6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-435ffe4 elementor-widget elementor-widget-heading\" data-id=\"435ffe4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1, C\u00e1ch Th\u00eam S\u1ed1 0 V\u00e0o S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Trong Excel \u0110\u01a1n Gi\u1ea3n Nh\u1ea5t<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9681988 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9681988\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b4e276c\" data-id=\"b4e276c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a92abd1 elementor-widget elementor-widget-heading\" data-id=\"a92abd1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-47626dba-7fff-9255-fdb0-0a428ff0a8ec\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1.1, C\u00e1ch Hi\u1ec7n S\u1ed1 0 Trong Excel B\u1eb1ng D\u1ea5u Nh\u00e1y \u0110\u01a1n<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5ea96c8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5ea96c8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-30dfbd8\" data-id=\"30dfbd8\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-64b8e01 elementor-widget elementor-widget-text-editor\" data-id=\"64b8e01\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-4489f74d-7fff-b821-99c4-fbb90e2603bf\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch \u0111\u00e1nh s\u1ed1 0 trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u1ea5t \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng d\u1ea5u nh\u00e1y \u0111\u01a1n \u2018 (apostrophe) tr\u01b0\u1edbc khi g\u00f5 s\u1ed1, khi \u0111\u00f3 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i s\u1ebd hi\u1ec3n th\u1ecb s\u1ed1 0 \u1edf \u0111\u1ea7u s\u1ed1:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4ac4963 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4ac4963\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-97e2d57\" data-id=\"97e2d57\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-990b5c8 elementor-widget elementor-widget-image\" data-id=\"990b5c8\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Them_dau_nhay_don_de_them_so_0_vao_so_dien_thoai_trong_Excel.jpg\" title=\"Them_dau_nhay_don_de_them_so_0_vao_so_dien_thoai_trong_Excel\" alt=\"Th\u00eam S\u1ed1 0 V\u00e0o S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Trong Excel B\u1eb1ng C\u00e1ch Th\u00eam D\u1ea5u Nh\u00e1y \u0110\u01a1n\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-06c5162 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"06c5162\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6649859\" data-id=\"6649859\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ba6b35b elementor-widget elementor-widget-heading\" data-id=\"ba6b35b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-cee83091-7fff-80b6-8a9c-f8e8ed046ab9\"><span style=\"font-size: 16pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1.2, Th\u00eam C\u00e1c K\u00fd T\u1ef1 \u0110\u1ec3 Kh\u00f4ng M\u1ea5t S\u1ed1 0 Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d4a42a1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d4a42a1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-51c4b27\" data-id=\"51c4b27\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e637d0c elementor-widget elementor-widget-text-editor\" data-id=\"e637d0c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-d3861ca1-7fff-a79e-0ade-56462111ec85\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">B\u1ea1n c\u00f3 th\u1ec3 th\u00eam d\u1ea5u c\u00e1ch, d\u1ea5u g\u1ea1ch ngang [ &#8211; ], d\u1ea5u ch\u1ea5m [ . ] \u0111\u1ec3 ng\u0103n c\u00e1ch gi\u1eefa s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u00e0 th\u00eam s\u1ed1 0 trong Excel nh\u01b0 sau: <\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5020cdc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5020cdc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e8b764b\" data-id=\"e8b764b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1ab38f4 elementor-widget elementor-widget-image\" data-id=\"1ab38f4\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Them-ky-tu-o-giua-ngan-cach-so-dien-thoai-de-hien-thi-so-0-trong-excel.png\" title=\"Them-ky-tu-o-giua-ngan-cach-so-dien-thoai-de-hien-thi-so-0-trong-excel\" alt=\"Th\u00eam C\u00e1c K\u00fd T\u1ef1 \u0110\u1ec3 Kh\u00f4ng M\u1ea5t S\u1ed1 0 Trong Excel Th\u00eam S\u1ed1 0 V\u00e0o \u0110\u1ea7u S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Trong Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a67c8f5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a67c8f5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d03e4db\" data-id=\"d03e4db\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-216fe6a elementor-widget elementor-widget-heading\" data-id=\"216fe6a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-bee0c248-7fff-a9a6-a466-f8a044cfcf53\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2, C\u00e1ch Th\u00eam S\u1ed1 0 V\u00e0o S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Trong Excel B\u1eb1ng C\u00e1ch Thay \u0110\u1ed5i \u0110\u1ecbnh D\u1ea1ng \u00d4<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8f49dcf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8f49dcf\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8e1b1e4\" data-id=\"8e1b1e4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-188a503 elementor-widget elementor-widget-text-editor\" data-id=\"188a503\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch vi\u1ebft s\u1ed1 0 \u1edf \u0111\u1ea7u trong Excel \u0111\u01b0\u1ee3c hoctin.vn hay s\u1eed d\u1ee5ng l\u00e0 t\u00f9y ch\u1ecdn Format Cells.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u01afu \u0111i\u1ec3m c\u1ee7a c\u00e1ch n\u00e0y l\u00e0 khi ph\u1ea3i nh\u1eadp danh s\u00e1ch s\u1ed1 \u0111i\u1ec7n tho\u1ea1i t\u1eeb v\u00e0i tr\u0103m \u0111\u1ebfn v\u00e0i ngh\u00ecn s\u1ed1 th\u00ec c\u00e1ch n\u00e0y nhanh v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian \u0111\u00e1ng k\u1ec3 so v\u1edbi c\u00e1c c\u00e1ch th\u1ee7 c\u00f4ng \u1edf tr\u00ean.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u00e0 b\u1ecf qua s\u1ed1 0 \u1edf \u0111\u1ea7u, v\u00ed d\u1ee5 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i 0123456789 ch\u1ec9 c\u1ea7n \u0111\u1ec3 l\u1ea1i s\u1ed1 \u0111i\u1ec7n tho\u1ea1i 123456789.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">Sau khi nh\u1eadp xong c\u00e1c s\u1ed1 \u0111i\u1ec7n tho\u1ea1i kh\u00f4ng c\u00f3 s\u1ed1 0 \u1edf \u0111\u1ea7u, \u0111\u1ecbnh d\u1ea1ng l\u1ea1i c\u00e1c \u00f4 \u0111\u00e3 nh\u1eadp b\u1eb1ng c\u00e1ch ch\u1ecdn \u00f4, v\u00e0o Home &gt;&gt; Number Format &gt;&gt; More Number Formats:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3592e14 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3592e14\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6c35f08\" data-id=\"6c35f08\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c8edf32 elementor-widget elementor-widget-image\" data-id=\"c8edf32\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Dung-format-cells-de-them-so-0-vao-so-dien-thoai-trong-excel-tu-home.jpg\" title=\"Dung-format-cells-de-them-so-0-vao-so-dien-thoai-trong-excel-tu-home\" alt=\"C\u00e1ch Th\u00eam +84 V\u00e0o S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Trong Excel B\u1eb1ng C\u00e1ch Thay \u0110\u1ed5i \u0110\u1ecbnh D\u1ea1ng \u00d4\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3391915 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3391915\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-19961e6\" data-id=\"19961e6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e0c9bf8 elementor-widget elementor-widget-text-editor\" data-id=\"e0c9bf8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u1ed9p tho\u1ea1i Format Cells hi\u1ec7n ra \u0111\u1ec3 b\u1ea1n t\u00f9y ch\u1ec9nh \u0111\u1ecbnh d\u1ea1ng s\u1ed1 c\u1ee7a c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn.<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&nbsp;<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i n\u00e0y l\u00e0 s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ctrl 1.<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&nbsp;<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">T\u1eeb h\u1ed9p tho\u1ea1i Format Cells, trong m\u1ee5c Number: <\/span><span style=\"color: #000000; font-family: Arial; font-size: 14.6667px; white-space: pre-wrap;\">ch\u1ecdn Custom &gt;&gt; <\/span><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">t\u1ea1i \u00f4 Type, g\u00f5 10 s\u1ed1 0 (m\u1eabu s\u1ed1 \u0111i\u1ec7n tho\u1ea1i c\u00f3 10 ch\u1eef s\u1ed1, \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i c\u00f3 bao nhi\u00eau ch\u1eef s\u1ed1 th\u00ec g\u00f5 b\u1ea5y nhi\u00eau s\u1ed1 0).<\/span><\/p>\n<p><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Khi \u0111\u00f3, t\u1ea1i m\u1ee5c Sample, Excel t\u1ef1 \u0111\u1ed9ng hi\u1ec7n ra m\u1eabu s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng t\u1eeb Type \u0111\u00e3 ch\u1ecdn, nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y s\u1ed1 123456789 \u1edf \u00f4 A3 hi\u1ec7n Sample \u0111\u00e3 ch\u00e8n th\u00eam s\u1ed1 0 trong Excel, k\u1ebft qu\u1ea3 l\u00e0 0123456789:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8c3d821 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8c3d821\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-27679b6\" data-id=\"27679b6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a59a0a1 elementor-widget elementor-widget-image\" data-id=\"a59a0a1\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Dung-format-cells-de-them-so-0-vao-so-dien-thoai-trong-excel.png\" title=\"Dung-format-cells-de-them-so-0-vao-so-dien-thoai-trong-excel\" alt=\"C\u00e1ch Th\u00eam +84 V\u00e0o S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Trong Excel B\u1eb1ng C\u00e1ch Thay \u0110\u1ed5i \u0110\u1ecbnh D\u1ea1ng \u00d4\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ac92877 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ac92877\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-03d792c\" data-id=\"03d792c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-07b8b55 elementor-widget elementor-widget-text-editor\" data-id=\"07b8b55\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-f0161567-7fff-bdf6-33fb-4670837b0f44\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch n\u00e0y c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng kh\u00f4ng ch\u1ec9 v\u1edbi s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, m\u00e0 c\u00f2n hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi nh\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 h\u00f3a \u0111\u01a1n. S\u1ed1 th\u1ee9 t\u1ef1 h\u00f3a \u0111\u01a1n ghi b\u1eb1ng d\u00e3y s\u1ed1 t\u1ef1 nhi\u00ean li\u00ean ti\u1ebfp c\u00f3 7 ch\u1eef s\u1ed1 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c Custom nh\u01b0 c\u00e1ch tr\u00ean b\u1eb1ng c\u00e1ch g\u00f5 0000000 (7 s\u1ed1 0) v\u00e0o \u00f4 Type.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3763d5e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3763d5e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-dd347ea\" data-id=\"dd347ea\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1bea4be elementor-widget elementor-widget-heading\" data-id=\"1bea4be\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-781ddf81-7fff-4fba-7687-ce8f2261815a\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3. C\u00e1ch Vi\u1ebft S\u1ed1 0 \u1ede \u0110\u1ea7u Trong Excel B\u1eb1ng H\u00e0m Text<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-64a7b14 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"64a7b14\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-83a307f\" data-id=\"83a307f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-24e0878 elementor-widget elementor-widget-text-editor\" data-id=\"24e0878\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant: normal; vertical-align: baseline; white-space: pre-wrap;\"><i style=\"font-family: Roboto, sans-serif; background-color: rgb(255, 255, 255); font-size: 18px;\"><b><a href=\"https:\/\/hoctin.vn\/ham-text-trong-excel\/\">H\u00e0m TEXT<\/a><\/b><\/i> \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 chuy\u1ec3n c\u00e1ch hi\u1ec3n th\u1ecb m\u1ed9t s\u1ed1 th\u00e0nh \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n b\u1eb1ng m\u00e3 \u0111\u1ecbnh d\u1ea1ng. Hoctin.vn s\u1eed d\u1ee5ng h\u00e0m Text \u0111\u1ec3 hi\u1ec3n th\u1ecb s\u1ed1 0 \u1edf \u0111\u1ea7u s\u1ed1 \u0111i\u1ec7n tho\u1ea1i nh\u01b0 sau:<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b style=\"font-weight: normal;\">&nbsp;<\/b><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m Text<\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"><br><\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=text(value,format_text)<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"margin-top: 0; margin-bottom: 0;\">\n<li dir=\"ltr\" style=\"list-style-type: disc; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\">\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Value l\u00e0 gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng<\/span><\/p>\n<\/li>\n<li dir=\"ltr\" style=\"list-style-type: disc; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\">\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Format_text l\u00e0 m\u00e3 \u0111\u1ecbnh d\u1ea1ng b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng.<\/span><\/p>\n<\/li>\n<\/ul>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b style=\"font-weight: normal;\">&nbsp;<\/b><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5: \u00f4 A3 ch\u1ee9a s\u1ed1 123456789<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">T\u1ea1i \u00f4 C3, g\u00f5 =text(A3,&#8221;0000000000&#8243;)<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\">\n<\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 0123456789. H\u00e0m n\u00e0y \u0111\u1ecbnh d\u1ea1ng \u00f4 A3 b\u1eb1ng \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n c\u00f3 10 ch\u1eef s\u1ed1 b\u1eb1ng c\u00e1ch \u0111\u1eb7t 10 s\u1ed1 0 trong ngo\u1eb7c k\u00e9p.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c8e7250 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c8e7250\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c820a2f\" data-id=\"c820a2f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-90f95f2 elementor-widget elementor-widget-image\" data-id=\"90f95f2\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Dung-ham-text-de-them-so-0-vao-so-dien-thoai-trong-excel.png\" title=\"Dung-ham-text-de-them-so-0-vao-so-dien-thoai-trong-excel\" alt=\"C\u00e1ch Vi\u1ebft S\u1ed1 0 \u1ede \u0110\u1ea7u S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Trong Excel B\u1eb1ng H\u00e0m Text\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-21a8fd9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"21a8fd9\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f9d4eff\" data-id=\"f9d4eff\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-06694db elementor-widget elementor-widget-text-editor\" data-id=\"06694db\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Hi v\u1ecdng b\u00e0i vi\u1ebft c\u1ee7a hoctin.vn \u0111\u00e3 mang l\u1ea1i cho c\u00e1c b\u1ea1n c\u00e1c th\u00f4ng tin h\u1eefu \u00edch v\u1ec1 c\u00e1c c\u00e1ch th\u00eam s\u1ed1 0 v\u00e0o s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel.<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&nbsp;<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ch\u00fac c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng th\u00e0nh c\u00f4ng trong c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp.<\/span><\/p>\n<p><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u00f3n \u0111\u1ecdc b\u00e0i vi\u1ebft:&nbsp; <a href=\"https:\/\/hoctin.vn\/them-dau-so-dien-thoai-84-trong-excel\/\" target=\"_blank\">C\u00e1ch th\u00eam +84 v\u00e0o \u0111\u1ea7u s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel<\/a>.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Khi nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u00e0o Excel, nhi\u1ec1u l\u00fac b\u1ea1n g\u1eb7p l\u1ed7i m\u1ea5t s\u1ed1 0 \u1edf \u0111\u1ea7u \u00f4 trong Excel. \u00a0 B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch th\u00eam s\u1ed1 0 v\u00e0o s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel t\u1eeb c\u00e1ch th\u1ee7 c\u00f4ng \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn c\u00e1ch nhanh nh\u1ea5t v\u00e0 t\u1ef1 \u0111\u1ed9ng nh\u1ea5t. \u00a0 M\u1ee5c L\u1ee5c &#8230; <a title=\"C\u00e1ch Th\u00eam S\u1ed1 0 V\u00e0o S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Trong Excel\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/cach-them-so-0-vao-so-dien-thoai-trong-excel\/\">Read more <span class=\"screen-reader-text\">C\u00e1ch Th\u00eam S\u1ed1 0 V\u00e0o S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Trong Excel<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":490,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[30],"tags":[80,7],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/475"}],"collection":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/comments?post=475"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/475\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/490"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=475"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=475"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}