{"id":1884,"date":"2020-12-24T14:53:55","date_gmt":"2020-12-24T07:53:55","guid":{"rendered":"https:\/\/hoctin.vn\/?p=1884"},"modified":"2020-12-24T14:53:58","modified_gmt":"2020-12-24T07:53:58","slug":"ham-text-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/ham-text-trong-excel\/","title":{"rendered":"C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m Text T\u00f9y Ch\u1ec9nh \u0110\u1ecbnh D\u1ea1ng S\u1ed1 Th\u00e0nh V\u0103n B\u1ea3n"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1884\" class=\"elementor elementor-1884\">\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-79008f7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"79008f7\" 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-1eda397\" data-id=\"1eda397\" 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-b6357da elementor-widget elementor-widget-text-editor\" data-id=\"b6357da\" 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.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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 TEXT trong Excel gi\u00fap b\u1ea1n thay \u0111\u1ed5i c\u00e1ch hi\u1ec3n th\u1ecb s\u1ed1 d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m TEXT \u0111\u1ec3 d\u1ec5 \u0111\u1ecdc s\u1ed1 h\u01a1n (v\u00ed d\u1ee5 th\u00eam d\u1ea5u ng\u0103n c\u00e1ch gi\u1eefa h\u00e0ng ngh\u00ecn, h\u00e0ng tri\u1ec7u\u2026) ho\u1eb7c k\u1ebft h\u1ee3p s\u1ed1 v\u1edbi chu\u1ed7i v\u0103n b\u1ea3n.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TEXT v\u00e0 c\u00e1c l\u01b0u \u00fd khi d\u00f9ng h\u00e0m n\u00e0y trong Excel 2007, 2010, 2013, 2016, 2019 v\u00e0 365.<\/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-3bdd803 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3bdd803\" 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-be180cf\" data-id=\"be180cf\" 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-0a83731 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"0a83731\" 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\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-3074153 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3074153\" 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-3ccc3b7\" data-id=\"3ccc3b7\" 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-ead53fc elementor-widget elementor-widget-heading\" data-id=\"ead53fc\" 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-b3cc5a38-7fff-6428-4bea-7b0ad7a90c47\"><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\u00fa Ph\u00e1p H\u00e0m TEXT Trong Excel V\u00e0 L\u01b0u \u00dd<\/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-9d306c9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9d306c9\" 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-7616120\" data-id=\"7616120\" 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-ea9e760 elementor-widget elementor-widget-text-editor\" data-id=\"ea9e760\" 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.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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;\">L\u1ec7nh TEXT trong Excel:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">Trong \u0111\u00f3:<\/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-cd51bca elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cd51bca\" 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-3a40d83\" data-id=\"3a40d83\" 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-e4d2142 elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"e4d2142\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span id=\"docs-internal-guid-2889dcce-7fff-2230-7f92-431a22944da3\"><span style=\"font-size: 12pt; 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;\">Value<\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">: s\u1ed1 c\u1ea7n \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i th\u00e0nh v\u0103n b\u1ea3n.<\/span><\/span><br><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span><p dir=\"ltr\" style=\"line-height:1.7999999999999998;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size: 12pt; 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;\">Format_text<\/span><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">: m\u00e3 \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng cho s\u1ed1 c\u1ea7n chuy\u1ec3n. C\u00e1c m\u00e3 n\u00e0y c\u1ea7n \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p \u201c\u201d. <\/span><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt;\">B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra c\u00e1c ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau d\u1ef1a tr\u00ean c\u00e1c m\u00e3 \u0111\u1ecbnh d\u1ea1ng g\u1ed1c nh\u01b0 sau:<\/span><\/p><\/span><br><span><ul style=\"margin-bottom: 0px;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height:1.7999999999999998;text-align: justify;margin-top:0pt;margin-bottom:0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u201c0\u201d <\/span><span style=\"font-size: 12pt; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0111\u1ea1i di\u1ec7n cho m\u1ed9t s\u1ed1 0, s\u1ed1 l\u01b0\u1ee3ng s\u1ed1 0 th\u1ec3 hi\u1ec7n s\u1ed1 ch\u1eef s\u1ed1 c\u1ea7n \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb khi d\u00f9ng h\u00e0m TEXT.<\/span><\/p><\/li><\/ul><p dir=\"ltr\" style=\"line-height:1.7999999999999998;margin-left: 36pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">N\u1ebfu s\u1ed1 c\u1ea7n chuy\u1ec3n c\u00f3 \u00edt ch\u1eef s\u1ed1 h\u01a1n th\u00ec c\u00e1c v\u1ecb tr\u00ed \u0111\u1ea7u s\u1ebd \u0111\u01b0\u1ee3c l\u1ea5p \u0111\u1ea7y b\u1eb1ng c\u00e1c s\u1ed1 0, v\u00ed d\u1ee5 TEXT(12, \u201c0000\u201d) tr\u1ea3 v\u1ec1 \u201c0012\u201d<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.7999999999999998;margin-left: 36pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">N\u1ebfu kh\u00f4ng th\u00ec s\u1ed1 d\u1ea1ng text \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean, nh\u01b0 TEXT(123, \u201c00\u201d) tr\u1ea3 v\u1ec1 \u201c123\u201d.<\/span><\/p><div><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\"><br><\/span><\/div><\/span><span><ul style=\"margin-bottom: 0px;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height:1.7999999999999998;text-align: justify;margin-top:0pt;margin-bottom:0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u201c#\u201d <\/span><span style=\"font-size: 12pt; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0111\u1ea1i di\u1ec7n cho m\u1ed9t ch\u1eef s\u1ed1 khi chuy\u1ec3n \u0111\u1ecbnh d\u1ea1ng s\u1ed1 sang text trong Excel.<\/span><\/p><\/li><\/ul><p dir=\"ltr\" style=\"line-height:1.7999999999999998;margin-left: 36pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">Nh\u1edd c\u00f3 k\u00fd t\u1ef1 #, b\u1ea1n c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp th\u00eam c\u00e1c k\u00ed t\u1ef1 kh\u00e1c \u0111\u1ec3 ng\u0103n c\u00e1ch s\u1ed1, v\u00ed d\u1ee5:<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.7999999999999998;margin-left: 36pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">TEXT(1234567, \"(###)##-##\") tr\u1ea3 v\u1ec1 \u201c(123)45-67\u201d.<\/span><\/p><br><ul style=\"margin-bottom: 0px;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height:1.7999999999999998;text-align: justify;margin-top:0pt;margin-bottom:0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">D\u1ea5u ng\u0103n c\u00e1ch ph\u1ea7n th\u1eadp ph\u00e2n l\u00e0 d\u1ea5u ch\u1ea5m, d\u1ea5u ng\u0103n h\u00e0ng ngh\u00ecn l\u00e0 d\u1ea5u ph\u1ea9y.<\/span><\/p><\/li><\/ul><p dir=\"ltr\" style=\"line-height:1.7999999999999998;margin-left: 36pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">\u0110\u1ec3 quy \u0111\u1ecbnh s\u1ed1 ch\u1eef s\u1ed1 ph\u1ea7n th\u1eadp ph\u00e2n \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb (n\u1ebfu c\u00f3) m\u00e0 kh\u00f4ng c\u1ea7n th\u00eam c\u00e1c s\u1ed1 0 v\u00f4 ngh\u0129a, s\u1eed d\u1ee5ng d\u1ea5u \u201c?\u201d. V\u00ed d\u1ee5:<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.7999999999999998;margin-left: 36pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">TEXT(12, \"#,??\") tr\u1ea3 v\u1ec1 \u201c12.\u201d<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.7999999999999998;margin-left: 36pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">TEXT(12.3, \"#,??\") tr\u1ea3 v\u1ec1 \u201c12.3\u201d<\/span><\/p><\/span><span><p dir=\"ltr\" style=\"line-height:1.7999999999999998;margin-left: 36pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt;\">TEXT(12.3456, \"#,??\") tr\u1ea3 v\u1ec1 \u201c12.35\u201d<\/span><\/p><\/span><span><br><ul style=\"margin-bottom: 0px;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 12pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height:1.7999999999999998;text-align: justify;margin-top:0pt;margin-bottom:0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">M\u1ed9t s\u1ed1 ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m nh\u01b0: dd\/mm\/yyyy, dddd, mmm d\u2026<\/span><span style=\"color: rgb(84, 89, 95); white-space: pre-wrap; font-family: Roboto, sans-serif; font-size: 18px;\"><\/span><\/p><\/li><\/ul><\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\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-49eb9bf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"49eb9bf\" 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-4e50693\" data-id=\"4e50693\" 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-e43b43c elementor-widget elementor-widget-text-editor\" data-id=\"e43b43c\" 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.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #1155cc; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">L\u01b0u \u00fd:<\/span> <span style=\"font-size: 12pt; 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 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel s\u1ebd chuy\u1ec3n \u0111\u1ed5i s\u1ed1 th\u00e0nh v\u0103n b\u1ea3n. B\u1ea1n c\u1ea7n c\u00e2n nh\u1eafc khi \u0111\u1ecbnh d\u1ea1ng text trong Excel v\u00ec \u0111i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 khi\u1ebfn vi\u1ec7c kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c d\u1eef li\u1ec7u \u0111\u00f3 \u0111\u1ec3 t\u00ednh to\u00e1n sau n\u00e0y.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">N\u1ebfu s\u1eed d\u1ee5ng h\u00e0m TEXT \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1, b\u1ea1n n\u00ean gi\u1eef l\u1ea1i d\u1eef li\u1ec7u g\u1ed1c \u0111\u1ec3 th\u1ef1c hi\u1ec7n tham chi\u1ebfu v\u00e0 t\u00ednh to\u00e1n v\u1ec1 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-a46b261 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a46b261\" 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-1b677cb\" data-id=\"1b677cb\" 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-f033409 elementor-widget elementor-widget-heading\" data-id=\"f033409\" 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-a27cb61d-7fff-7627-8735-810c8ff7d1d8\"><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, V\u00ed D\u1ee5 H\u00e0m Chuy\u1ec3n S\u1ed1 Th\u00e0nh Chu\u1ed7i Trong Excel<\/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-96ff72f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"96ff72f\" 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-7016182\" data-id=\"7016182\" 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-5142d76 elementor-widget elementor-widget-text-editor\" data-id=\"5142d76\" 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-5cd04cfd-7fff-b9d0-4d58-154190019b5f\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5 v\u1ec1 c\u00e1ch chuy\u1ec3n s\u1ed1 th\u00e0nh chu\u1ed7i v\u0103n b\u1ea3n b\u1eb1ng h\u00e0m TEXT:<\/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-df5cedf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"df5cedf\" 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-9932b62\" data-id=\"9932b62\" 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-e0ad274 elementor-widget elementor-widget-image\" data-id=\"e0ad274\" 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\/12\/ham-text-chuyen-dinh-dang-so-sang-text-trong-excel.png\" title=\"ham-text-chuyen-dinh-dang-so-sang-text-trong-excel\" alt=\"V\u00ed D\u1ee5 H\u00e0m Chuy\u1ec3n S\u1ed1 Th\u00e0nh Chu\u1ed7i Trong Excel 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-a7fc642 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a7fc642\" 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-caed245\" data-id=\"caed245\" 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-880b71c elementor-widget elementor-widget-text-editor\" data-id=\"880b71c\" 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.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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 l\u00e0m n\u00e0y c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng trong vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, th\u00eam m\u00e3 v\u00f9ng, m\u00e3 qu\u1ed1c gia trong Excel:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/them-dau-so-dien-thoai-84-trong-excel\/\" target=\"_blank\" rel=\"noopener\"><b><i>C\u00e1ch Th\u00eam \u0110\u1ea7u S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Vi\u1ec7t Nam +84 Trong Excel<\/i><\/b><\/a><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b style=\"background-color: #ffffff;\"><i><a style=\"background-color: #ffffff;\" href=\"https:\/\/hoctin.vn\/cach-them-so-0-vao-so-dien-thoai-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch Th\u00eam S\u1ed1 0 V\u00e0o S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Trong Excel<\/a><\/i><\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b style=\"background-color: #ffffff;\">\u00a0<\/b><\/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-f9ae597 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f9ae597\" 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-9ac565d\" data-id=\"9ac565d\" 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-d061b56 elementor-widget elementor-widget-heading\" data-id=\"d061b56\" 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-4c748527-7fff-a9e8-c8fb-a9f0ecff845d\"><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, V\u00ed D\u1ee5 C\u00e1ch Ch\u00e8n K\u00fd Hi\u1ec7u V\u00e0o S\u1ed1 \u0110\u1ec3 \u0110\u1ecbnh D\u1ea1ng Ch\u1eef Trong Excel<\/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-c8873b0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c8873b0\" 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-9cbcdb0\" data-id=\"9cbcdb0\" 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-c4374b2 elementor-widget elementor-widget-text-editor\" data-id=\"c4374b2\" 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-13a0c4f2-7fff-fd66-36e8-031342a24d19\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng h\u00e0m TEXT \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7, v\u00ed d\u1ee5 &#8220;Gi\u00e1 tr\u1ecb $10,000,000,000.0&#8221;, trong \u0111\u00f3 s\u1ed1 \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng b\u1eb1ng k\u00fd hi\u1ec7u ti\u1ec1n t\u1ec7 v\u00e0 d\u1ea5u ph\u00e2n c\u00e1ch h\u00e0ng ngh\u00ecn v\u00e0 h\u00e0ng th\u1eadp ph\u00e2n:<\/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-55afda1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"55afda1\" 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-03457d2\" data-id=\"03457d2\" 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-45a22a4 elementor-widget elementor-widget-image\" data-id=\"45a22a4\" 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\/12\/ham-chuyen-so-thanh-chuoi-trong-excel-chuyen-dinh-dang-tien-te.png\" title=\"ham-chuyen-so-thanh-chuoi-trong-excel-chuyen-dinh-dang-tien-te\" alt=\"V\u00ed D\u1ee5 C\u00e1ch Ch\u00e8n K\u00fd Hi\u1ec7u V\u00e0o S\u1ed1 \u0110\u1ec3 \u0110\u1ecbnh D\u1ea1ng Ch\u1eef Trong Excel D\u1ea1ng Ti\u1ec1n T\u1ec7\" \/>\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-a2d4ffa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a2d4ffa\" 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-252c13f\" data-id=\"252c13f\" 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-d975e0b elementor-widget elementor-widget-heading\" data-id=\"d975e0b\" 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-93576a38-7fff-9a08-c3b4-49585ad54b17\"><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;\">4, V\u00ed D\u1ee5 C\u00e1ch Chuy\u1ec3n Ng\u00e0y Th\u00e1ng N\u0103m Sang D\u1ea1ng 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-81979cf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"81979cf\" 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-3ba0b8c\" data-id=\"3ba0b8c\" 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-146add5 elementor-widget elementor-widget-text-editor\" data-id=\"146add5\" 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.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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 b\u1ea1n mu\u1ed1n k\u1ebft h\u1ee3p ng\u00e0y v\u00e0 chu\u1ed7i v\u0103n b\u1ea3n th\u00ec \u0111\u1ecbnh d\u1ea1ng ng\u00e0y \u0111\u01b0\u1ee3c Excel m\u1eb7c \u0111\u1ecbnh l\u00e0 d\u1ea1ng s\u1ed1 serial.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; white-space: pre-wrap;\">\u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 m\u1eb7c d\u00f9 b\u1ea1n mu\u1ed1n nh\u00ecn th\u1ea5y ng\u00e0y ki\u1ec3u nh\u01b0 \u201cH\u00f4m nay l\u00e0 ng\u00e0y 24\/12\/2020\u201d th\u00ec Excel s\u1ebd hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c =\u201cH\u00f4m nay l\u00e0 ng\u00e0y \u201d &amp; TODAY() l\u00e0 \u201cH\u00f4m nay l\u00e0 ng\u00e0y 44189\u201d.<\/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-d6717bf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d6717bf\" 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-be62a0f\" data-id=\"be62a0f\" 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-3f00dea elementor-widget elementor-widget-text-editor\" data-id=\"3f00dea\" 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-807e428c-7fff-24b3-0236-f579a50f3698\"><span style=\"font-size: 12pt; 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\u1ea7n chuy\u1ec3n ng\u00e0y th\u00e1ng sang d\u1ea1ng text b\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p h\u00e0m TEXT v\u00e0 TODAY() nh\u01b0 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/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-68be89d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"68be89d\" 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-db23451\" data-id=\"db23451\" 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-66673fa elementor-widget elementor-widget-image\" data-id=\"66673fa\" 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\/12\/ket-hop-ham-text-va-today-chuyen-ngay-hom-nay-sang-dang-text-trong-excel.png\" title=\"ket-hop-ham-text-va-today-chuyen-ngay-hom-nay-sang-dang-text-trong-excel\" alt=\"V\u00ed D\u1ee5 C\u00e1ch Chuy\u1ec3n Ng\u00e0y Th\u00e1ng N\u0103m Sang D\u1ea1ng 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-98da011 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"98da011\" 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-5785a4d\" data-id=\"5785a4d\" 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-77281b7 elementor-widget elementor-widget-text-editor\" data-id=\"77281b7\" 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-44567f21-7fff-ce6f-ec27-0ebabf4d24f5\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Nh\u1edd c\u00f3 h\u00e0m TEXT, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 gh\u00e9p 2 ng\u00e0y l\u1ea1i \u0111\u1ec3 t\u1ea1o th\u00e0nh 1 kho\u1ea3ng th\u1eddi gian nh\u01b0: \u201cJan 8 &#8211; Nov 20 2020\u201d. M\u1ed9t s\u1ed1 \u0111\u1ecbnh d\u1ea1ng kh\u00e1c c\u1ee7a ng\u00e0y th\u00e1ng n\u0103m trong Excel khi \u00e1p d\u1ee5ng h\u00e0m TEXT \u0111\u01b0\u1ee3c n\u00eau trong v\u00ed d\u1ee5 minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y:<\/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-85ee034 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"85ee034\" 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-ab460ab\" data-id=\"ab460ab\" 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-9a30b96 elementor-widget elementor-widget-image\" data-id=\"9a30b96\" 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\/12\/cach-chuyen-ngay-thang-nam-sang-dang-text-voi-ham-text-trong-excel.png\" title=\"cach-chuyen-ngay-thang-nam-sang-dang-text-voi-ham-text-trong-excel\" alt=\"V\u00ed d\u1ee5 c\u00e1ch chuy\u1ec3n ng\u00e0y th\u00e1ng sang d\u1ea1ng text 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-5f36780 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5f36780\" 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-0c48777\" data-id=\"0c48777\" 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-b37847c elementor-widget elementor-widget-text-editor\" data-id=\"b37847c\" 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.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; 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 chuy\u1ec3n s\u1ed1 th\u00e0nh chu\u1ed7i trong Excel v\u1edbi h\u00e0m TEXT.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 12pt; 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>\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-36e53b1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"36e53b1\" 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-a474a84\" data-id=\"a474a84\" 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-19d6411 elementor-widget elementor-widget-text-editor\" data-id=\"19d6411\" 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.7999999999999998; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Arial; color: #000000; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ngo\u00e0i ra, \u0111\u1ec3 \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3 Excel, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel, h\u00e3y c\u00f9ng \u0111\u00f3n \u0111\u1ecdc series b\u00e0i vi\u1ebft \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m Excel:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 2.16; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-noi-chuoi-trong-excel\/\" target=\"_blank\" rel=\"noopener\"><i><b>H\u00e0m N\u1ed1i Chu\u1ed7i CONCATENATE, CONCAT v\u00e0 TEXTJOIN<\/b><\/i><\/a><\/p><p dir=\"ltr\" style=\"line-height: 2.16; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b><i><a href=\"https:\/\/hoctin.vn\/ham-noi-chuoi-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m VALUE Chuy\u1ec3n Chu\u1ed7i Th\u00e0nh S\u1ed1<\/a><br \/><\/i><\/b><\/p><p dir=\"ltr\" style=\"line-height: 2.16; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><a style=\"background-color: #ffffff;\" href=\"https:\/\/hoctin.vn\/ham-lay-ky-tu-bat-ky-trong-excel\/\" target=\"_blank\" rel=\"noopener\"><b><i>H\u00e0m L\u1ea5y K\u00fd T\u1ef1 B\u1ea5t K\u1ef3 Trong Excel<\/i><\/b><\/a><\/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>H\u00e0m TEXT trong Excel gi\u00fap b\u1ea1n thay \u0111\u1ed5i c\u00e1ch hi\u1ec3n th\u1ecb s\u1ed1 d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m TEXT \u0111\u1ec3 d\u1ec5 \u0111\u1ecdc s\u1ed1 h\u01a1n (v\u00ed d\u1ee5 th\u00eam d\u1ea5u ng\u0103n c\u00e1ch gi\u1eefa h\u00e0ng ngh\u00ecn, h\u00e0ng tri\u1ec7u\u2026) ho\u1eb7c k\u1ebft h\u1ee3p s\u1ed1 v\u1edbi chu\u1ed7i v\u0103n b\u1ea3n. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n &#8230; <a title=\"C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m Text T\u00f9y Ch\u1ec9nh \u0110\u1ecbnh D\u1ea1ng S\u1ed1 Th\u00e0nh V\u0103n B\u1ea3n\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/ham-text-trong-excel\/\">Read more <span class=\"screen-reader-text\">C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m Text T\u00f9y Ch\u1ec9nh \u0110\u1ecbnh D\u1ea1ng S\u1ed1 Th\u00e0nh V\u0103n B\u1ea3n<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":1886,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[80],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1884"}],"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=1884"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/1884\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/1886"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=1884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=1884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=1884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}