{"id":2825,"date":"2024-12-24T14:14:30","date_gmt":"2024-12-24T07:14:30","guid":{"rendered":"https:\/\/trannghiait.com\/?p=2825"},"modified":"2024-12-24T14:14:30","modified_gmt":"2024-12-24T07:14:30","slug":"cach-chuyen-gia-tri-co-dinh-dang-ngay-thang-nam-sang-dinh-dang-text-khong-bi-thay-doi-gia-tri","status":"publish","type":"post","link":"https:\/\/trannghiait.com\/index.php\/2024\/12\/24\/cach-chuyen-gia-tri-co-dinh-dang-ngay-thang-nam-sang-dinh-dang-text-khong-bi-thay-doi-gia-tri\/","title":{"rendered":"C\u00e1ch chuy\u1ec3n gi\u00e1 tr\u1ecb c\u00f3 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m sang \u0111\u1ecbnh d\u1ea1ng TEXT kh\u00f4ng b\u1ecb thay \u0111\u1ed5i gi\u00e1 tr\u1ecb"},"content":{"rendered":"\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_64 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/trannghiait.com\/index.php\/2024\/12\/24\/cach-chuyen-gia-tri-co-dinh-dang-ngay-thang-nam-sang-dinh-dang-text-khong-bi-thay-doi-gia-tri\/#Huong_dan_su_dung_ham_TEXT_trong_Excel\" title=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m =TEXT( ) trong Excel\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m =TEXT( ) trong Excel<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/trannghiait.com\/index.php\/2024\/12\/24\/cach-chuyen-gia-tri-co-dinh-dang-ngay-thang-nam-sang-dinh-dang-text-khong-bi-thay-doi-gia-tri\/#Cong_thuc_ham_TEXT\" title=\"C\u00f4ng th\u1ee9c h\u00e0m TEXT\">C\u00f4ng th\u1ee9c h\u00e0m TEXT<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/trannghiait.com\/index.php\/2024\/12\/24\/cach-chuyen-gia-tri-co-dinh-dang-ngay-thang-nam-sang-dinh-dang-text-khong-bi-thay-doi-gia-tri\/#Dinh_dang_%E2%80%9Cmmddyyyy%E2%80%9D\" title=\"\u0110\u1ecbnh d\u1ea1ng &#8220;mm\/dd\/yyyy&#8221;\">\u0110\u1ecbnh d\u1ea1ng &#8220;mm\/dd\/yyyy&#8221;<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/trannghiait.com\/index.php\/2024\/12\/24\/cach-chuyen-gia-tri-co-dinh-dang-ngay-thang-nam-sang-dinh-dang-text-khong-bi-thay-doi-gia-tri\/#Vi_du_minh_hoe\" title=\"V\u00ed d\u1ee5 minh h\u1ecd\u1ec7\">V\u00ed d\u1ee5 minh h\u1ecd\u1ec7<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/trannghiait.com\/index.php\/2024\/12\/24\/cach-chuyen-gia-tri-co-dinh-dang-ngay-thang-nam-sang-dinh-dang-text-khong-bi-thay-doi-gia-tri\/#Luu_y_quan_trong\" title=\"L\u01b0u \u00fd quan tr\u1ecdng\">L\u01b0u \u00fd quan tr\u1ecdng<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/trannghiait.com\/index.php\/2024\/12\/24\/cach-chuyen-gia-tri-co-dinh-dang-ngay-thang-nam-sang-dinh-dang-text-khong-bi-thay-doi-gia-tri\/#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Huong_dan_su_dung_ham_TEXT_trong_Excel\"><\/span>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m <code>=TEXT( )<\/code> trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p>H\u00e0m <code>TEXT<\/code> trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 c\u1ef1c k\u1ef3 h\u1eefu \u00edch, cho ph\u00e9p b\u1ea1n chuy\u1ec3n \u0111\u1ed5i gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4 sang d\u1ea1ng chu\u1ed7i v\u0103n b\u1ea3n v\u00e0 \u0111\u1ecbnh d\u1ea1ng theo mong mu\u1ed1n. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m <code>TEXT<\/code> \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i ng\u00e0y th\u00e1ng sang d\u1ea1ng &#8220;mm\/dd\/yyyy&#8221;.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cong_thuc_ham_TEXT\"><\/span>C\u00f4ng th\u1ee9c h\u00e0m <code>TEXT<\/code><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C\u00f4ng th\u1ee9c chung c\u1ee7a h\u00e0m <code>TEXT<\/code> l\u00e0:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=TEXT(value, format_text)\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>value<\/strong>: L\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n chuy\u1ec3n \u0111\u1ed5i (c\u00f3 th\u1ec3 l\u00e0 tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t h\u00e0m kh\u00e1c).<\/li>\n\n\n\n<li><strong>format_text<\/strong>: L\u00e0 chu\u1ed7i v\u0103n b\u1ea3n \u0111\u1ecbnh d\u1ea1ng mong mu\u1ed1n, \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p (&#8220;).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Dinh_dang_%E2%80%9Cmmddyyyy%E2%80%9D\"><\/span>\u0110\u1ecbnh d\u1ea1ng &#8220;mm\/dd\/yyyy&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Trong c\u00e2u h\u00e0m <code>TEXT<\/code>, c\u00e1c k\u00fd t\u1ef1 \u0111\u1ecbnh d\u1ea1ng cho ng\u00e0y th\u00e1ng bao g\u1ed3m:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>mm<\/strong>: Hi\u1ec3n th\u1ecb th\u00e1ng b\u1eb1ng hai ch\u1eef s\u1ed1.<\/li>\n\n\n\n<li><strong>dd<\/strong>: Hi\u1ec3n th\u1ecb ng\u00e0y b\u1eb1ng hai ch\u1eef s\u1ed1.<\/li>\n\n\n\n<li><strong>yyyy<\/strong>: Hi\u1ec3n th\u1ecb n\u0103m b\u1eb1ng b\u1ed1n ch\u1eef s\u1ed1.<\/li>\n<\/ul>\n\n\n\n<p>Khi \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng &#8220;mm\/dd\/yyyy&#8221;, ng\u00e0y th\u00e1ng s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n sang d\u1ea1ng th\u00e1ng\/\u0111\u1ea7u ti\u00ean, sau \u0111\u00f3 l\u00e0 ng\u00e0y, v\u00e0 cu\u1ed1i c\u00f9ng l\u00e0 n\u0103m.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Vi_du_minh_hoe\"><\/span>V\u00ed d\u1ee5 minh h\u1ecd\u1ec7<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Gi\u1ea3 s\u1eed, b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng Excel nh\u01b0 sau:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>A<\/th><th>B<\/th><\/tr><\/thead><tbody><tr><td>Ng\u00e0y g\u1ed1c<\/td><td>Ng\u00e0y \u0111\u1ecbnh d\u1ea1ng<\/td><\/tr><tr><td>12\/24\/2024<\/td><td><\/td><\/tr><tr><td>01\/15\/2023<\/td><td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Trong \u00f4 <strong>B2<\/strong>, nh\u1eadp c\u00f4ng th\u1ee9c sau: <code>=TEXT(A2, \"mm\/dd\/yyyy\")<\/code><\/li>\n\n\n\n<li>Nh\u1ea5n <strong>Enter<\/strong>, b\u1ea1n s\u1ebd th\u1ea5y k\u1ebft qu\u1ea3 hi\u1ec7n l\u00ean trong \u00f4 B2 v\u1edbi \u0111\u1ecbnh d\u1ea1ng &#8220;mm\/dd\/yyyy&#8221;.<\/li>\n\n\n\n<li>Sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng d\u00f2ng d\u01b0\u1edbi (\u00f4 B3), v\u00e0 Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<\/ol>\n\n\n\n<p>Sau khi thao t\u00e1c, b\u1ea3ng s\u1ebd nh\u01b0 sau:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>A<\/th><th>B<\/th><\/tr><\/thead><tbody><tr><td>Ng\u00e0y g\u1ed1c<\/td><td>Ng\u00e0y \u0111\u1ecbnh d\u1ea1ng<\/td><\/tr><tr><td>12\/24\/2024<\/td><td>12\/24\/2024<\/td><\/tr><tr><td>01\/15\/2023<\/td><td>01\/15\/2023<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Luu_y_quan_trong\"><\/span>L\u01b0u \u00fd quan tr\u1ecdng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>H\u00e0m <code>TEXT<\/code> tr\u1ea3 v\u1ec1 chu\u1ed7i v\u0103n b\u1ea3n<\/strong>: Gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i b\u1eb1ng h\u00e0m <code>TEXT<\/code> l\u00e0 chu\u1ed7i, ngay c\u1ea3 khi b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u1edbi s\u1ed1.<\/li>\n\n\n\n<li><strong>\u0110\u1ecbnh d\u1ea1ng chu\u1ed7i<\/strong>: C\u1ea7n ch\u00fa \u00fd nh\u1eadp ch\u00ednh x\u00e1c \u0111\u1ecbnh d\u1ea1ng trong d\u1ea5u ngo\u1eb7c k\u00e9p (&#8220;).<\/li>\n\n\n\n<li><strong>H\u1ee7y b\u1ecf d\u1ecbnh d\u1ea1ng<\/strong>: N\u1ebfu mu\u1ed1n quay l\u1ea1i d\u1ea1ng ng\u00e0y ban \u0111\u1ea7u, b\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p v\u00e0 d\u00e1n d\u1eef li\u1ec7u nh\u01b0 gi\u00e1 tr\u1ecb t\u0129nh.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>H\u00e0m <code>TEXT<\/code> trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i v\u00e0 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng theo nhu c\u1ea7u c\u1ee7a b\u1ea1n. Vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng ng\u00e0y d\u1ea1ng &#8220;mm\/dd\/yyyy&#8221; gi\u00fap t\u0103ng t\u00ednh \u0111\u1ed3ng nh\u1ea5t khi chia s\u1ebb ho\u1eb7c xu\u1ea5t b\u1ea3ng d\u1eef li\u1ec7u. H\u00e3y th\u1eed nghi\u1ec7m \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u00e0 \u00e1p d\u1ee5ng trong c\u00e1c t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf c\u1ee7a b\u1ea1n.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m =TEXT( ) trong Excel H\u00e0m TEXT trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 c\u1ef1c k\u1ef3 h\u1eefu \u00edch, cho ph\u00e9p b\u1ea1n chuy\u1ec3n <a class=\"mh-excerpt-more\" href=\"https:\/\/trannghiait.com\/index.php\/2024\/12\/24\/cach-chuyen-gia-tri-co-dinh-dang-ngay-thang-nam-sang-dinh-dang-text-khong-bi-thay-doi-gia-tri\/\" title=\"C\u00e1ch chuy\u1ec3n gi\u00e1 tr\u1ecb c\u00f3 \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m sang \u0111\u1ecbnh d\u1ea1ng TEXT kh\u00f4ng b\u1ecb thay \u0111\u1ed5i gi\u00e1 tr\u1ecb\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":776,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-2825","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc-excel"],"_links":{"self":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/2825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/comments?post=2825"}],"version-history":[{"count":1,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/2825\/revisions"}],"predecessor-version":[{"id":2826,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/2825\/revisions\/2826"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media\/776"}],"wp:attachment":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media?parent=2825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/categories?post=2825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/tags?post=2825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}