{"id":9606,"date":"2025-01-02T11:06:39","date_gmt":"2025-01-02T11:06:39","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-chuyen-tu-ngay-thang-date-ve-dinh-dang-so-number-hoac-chu-text-trong-excel\/"},"modified":"2025-01-02T11:06:39","modified_gmt":"2025-01-02T11:06:39","slug":"huong-dan-cach-chuyen-tu-ngay-thang-date-ve-dinh-dang-so-number-hoac-chu-text-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-chuyen-tu-ngay-thang-date-ve-dinh-dang-so-number-hoac-chu-text-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng (Date) v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 (Number) ho\u1eb7c ch\u1eef (Text) trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef th\u00f4ng qua 2 t\u00ecnh hu\u1ed1ng: \u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng (Date) ho\u1eb7c ng\u00e0y th\u00e1ng v\u1edbi \u0111\u1ecbnh d\u1ea1ng ch\u1eef (Text).<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6776733e52c99\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/chuyen-tu-ngay-thang-date-ve-dinh-dang-number-hoac-chu-text.html#Chuyen_tu_ngay_thang_ve_dinh_dang_so_hoac_chu\" title=\"Chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\">Chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/chuyen-tu-ngay-thang-date-ve-dinh-dang-number-hoac-chu-text.html#Chuyen_tu_ngay_thang_ve_dinh_dang_chu\" title=\"Chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng ch\u1eef\">Chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng ch\u1eef<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/chuyen-tu-ngay-thang-date-ve-dinh-dang-number-hoac-chu-text.html#Dua_ngay_thang_ve_dinh_dang_so_Number\" title=\"\u0110\u01b0a ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 (Number)\">\u0110\u01b0a ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 (Number)<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/chuyen-tu-ngay-thang-date-ve-dinh-dang-number-hoac-chu-text.html#Chuyen_du_lieu_kieu_ngay_thang_duoc_dinh_dang_Text_ve_Number\" title=\"Chuy\u1ec3n d\u1eef li\u1ec7u ki\u1ec3u ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng Text v\u1ec1 Number\">Chuy\u1ec3n d\u1eef li\u1ec7u ki\u1ec3u ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng Text v\u1ec1 Number<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/chuyen-tu-ngay-thang-date-ve-dinh-dang-number-hoac-chu-text.html#KHONG_NEN_dinh_dang_lai\" title=\"KH\u00d4NG N\u00caN \u0111\u1ecbnh d\u1ea1ng l\u1ea1i\">KH\u00d4NG N\u00caN \u0111\u1ecbnh d\u1ea1ng l\u1ea1i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/chuyen-tu-ngay-thang-date-ve-dinh-dang-number-hoac-chu-text.html#Su_dung_ham_DATEVALUE\" title=\"S\u1eed d\u1ee5ng\u00a0h\u00e0m DATEVALUE\">S\u1eed d\u1ee5ng\u00a0h\u00e0m DATEVALUE<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/chuyen-tu-ngay-thang-date-ve-dinh-dang-number-hoac-chu-text.html#Su_dung_Text_to_column\" title=\"S\u1eed d\u1ee5ng\u00a0Text to column\">S\u1eed d\u1ee5ng\u00a0Text to column<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/chuyen-tu-ngay-thang-date-ve-dinh-dang-number-hoac-chu-text.html#Su_dung_Flashfill\" title=\"S\u1eed d\u1ee5ng Flashfill\">S\u1eed d\u1ee5ng Flashfill<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Chuyen_tu_ngay_thang_ve_dinh_dang_so_hoac_chu\"><\/span>Chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Chuyen_tu_ngay_thang_ve_dinh_dang_chu\"><\/span>Chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng ch\u1eef<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u00f4i khi b\u1ea1n kh\u00f4ng mu\u1ed1n nh\u1eefng \u00f4 ch\u1ee9a d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng c\u1ee7a m\u00ecnh tham gia v\u00e0o t\u00ednh to\u00e1n. Trong tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3, chuy\u1ec3n \u0111\u1ecbnh d\u1ea1ng v\u1ec1\u00a0<strong>Text<\/strong> l\u00e0 m\u1ed9t c\u00e1ch gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y.<\/p>\n<figure id=\"attachment_23891\" aria-describedby=\"caption-attachment-23891\" style=\"width: 315px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23891 size-full\" title=\"1 - chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/date-to-text-or-number-1.png\" alt=\"1 - chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" width=\"315\" height=\"133\"><figcaption id=\"caption-attachment-23891\" class=\"wp-caption-text\">1 \u2013 chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef<\/figcaption><\/figure>\n<p>T\u1ea1i \u00f4 C1 ta nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n<p><em>=TEXT(B2,\u201ddd\/mm\/yyyy\u201d)<\/em><\/p>\n<p>H\u00e0m TEXT s\u1ebd x\u00e1c nh\u1eadn \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n chuy\u1ec3n l\u00e0 \u00f4\u00a0<strong>B2<\/strong>, v\u1edbi \u0111\u1ecbnh d\u1ea1ng l\u00e0\u00a0<strong>ng\u00e0y\/th\u00e1ng\/n\u0103m<\/strong>.<\/p>\n<p>M\u1eb7t kh\u00e1c, \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>Date<\/strong> c\u0169ng ch\u00ednh l\u00e0 m\u1ed9t bi\u1ebfn th\u1ec3 t\u1eeb\u00a0<strong>Number<\/strong>, \u0111\u01b0\u1ee3c quy \u0111\u1ecbnh:<\/p>\n<p>S\u1ed1 01 = 01\/01\/1900<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-71.gif\" title=\"ex101_92019-nho-71\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>02 = 02\/01\/1900<\/p>\n<p>\u2026<\/p>\n<p><em>21\/11\/2018 =\u00a043425<\/em><\/p>\n<p>N\u1ebfu ta mu\u1ed1n gi\u1eef ng\u00e0y th\u00e1ng v\u1edbi \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>Text<\/strong>, hi\u1ec3n th\u1ecb b\u1eb1ng nh\u1eefng con s\u1ed1, h\u00e3y nh\u1eadp:<\/p>\n<p><em>=TEXT(B2,\u201d0\u2033)<\/em><\/p>\n<figure id=\"attachment_23892\" aria-describedby=\"caption-attachment-23892\" style=\"width: 316px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23892 size-full\" title=\"2- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/date-to-text-or-number-2.png\" alt=\"2- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" width=\"316\" height=\"127\"><figcaption id=\"caption-attachment-23892\" class=\"wp-caption-text\">2- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef<\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Dua_ngay_thang_ve_dinh_dang_so_Number\"><\/span>\u0110\u01b0a ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 (Number)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 \u0111\u01b0a ng\u00e0y th\u00e1ng v\u1ec1 th\u00e0nh c\u00e1c con s\u1ed1 c\u1ee7a \u0111\u1ecbnh d\u1ea1ng Number, ta ch\u1ec9 \u0111\u01a1n gi\u1ea3n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng trong th\u1ebb\u00a0<strong>Home<\/strong>, nh\u00f3m\u00a0<strong>Number<\/strong>, ch\u1ecdn\u00a0<strong>Date<\/strong> v\u00e0 chuy\u1ec3n th\u00e0nh\u00a0<strong>Number.\u00a0<\/strong>Ho\u1eb7c click chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 v\u00e0 ch\u1ecdn\u00a0<strong>Format Cells\u2026<\/strong>sau \u0111\u00f3 ch\u1ecdn\u00a0<strong>Number<\/strong> trong th\u1ebb Number.<\/p>\n<figure id=\"attachment_23893\" aria-describedby=\"caption-attachment-23893\" style=\"width: 534px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23893 size-full\" title=\"3- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/date-to-text-or-number-3.png\" alt=\"3- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" width=\"534\" height=\"462\"><figcaption id=\"caption-attachment-23893\" class=\"wp-caption-text\">3- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Chuyen_du_lieu_kieu_ngay_thang_duoc_dinh_dang_Text_ve_Number\"><\/span>Chuy\u1ec3n d\u1eef li\u1ec7u ki\u1ec3u ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng Text v\u1ec1 Number<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00f4i khi, d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng theo ki\u1ec3u Text, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 chuy\u1ec3n l\u1ea1i \u0111\u00e2y?<\/p>\n<figure id=\"attachment_23894\" aria-describedby=\"caption-attachment-23894\" style=\"width: 401px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23894 size-full\" title=\"4- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/date-to-text-or-number-4.png\" alt=\"4- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" width=\"401\" height=\"166\"><figcaption id=\"caption-attachment-23894\" class=\"wp-caption-text\">4- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef<\/figcaption><\/figure>\n<p>C\u00f3 nhi\u1ec1u l\u00ed do \u0111\u1ec3 ng\u00e0y th\u00e1ng c\u1ee7a b\u1ea1n nh\u1eadp v\u00e0o \u0111\u1ecbnh d\u1ea1ng Text. Ta s\u1ebd \u0111\u1ebfn v\u1edbi nh\u1eefng c\u00e1ch x\u1eed l\u00ed d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<h4><span class=\"ez-toc-section\" id=\"KHONG_NEN_dinh_dang_lai\"><\/span><strong>KH\u00d4NG N\u00caN<\/strong> \u0111\u1ecbnh d\u1ea1ng l\u1ea1i<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>M\u1ed9t c\u00e1ch ph\u1ed5 th\u00f4ng nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng \u0111\u00f3 l\u00e0 \u0111\u1ecbnh d\u1ea1ng l\u1ea1i trong h\u1ed9p tho\u1ea1i\u00a0Format Cells.<\/p>\n<figure id=\"attachment_23895\" aria-describedby=\"caption-attachment-23895\" style=\"width: 628px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23895 size-full\" title=\"5- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/date-to-text-or-number-5.png\" alt=\"5- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" width=\"628\" height=\"505\"><figcaption id=\"caption-attachment-23895\" class=\"wp-caption-text\">5- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef<\/figcaption><\/figure>\n<p>Tuy nhi\u00ean, sau khi l\u00e0m xong, v\u1ea5n \u0111\u1ec1 x\u1ea3y ra \u0111\u00f3 l\u00e0 c\u00e1c \u00f4 kh\u00f4ng t\u1ef1 chuy\u1ec3n m\u00e0 ta ph\u1ea3i thao t\u00e1c tay v\u00e0o t\u1eebng \u00f4 (click \u0111\u00fap chu\u1ed9t ch\u1ec9nh s\u1eeda) m\u1edbi th\u1ea5y hi\u1ec7u qu\u1ea3.<\/p>\n<p>N\u1ebfu c\u00f3 \u00edt d\u1eef li\u1ec7u, \u0111\u00e2y c\u0169ng \u0111\u01b0\u1ee3c coi l\u00e0 m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng \u201cch\u1eefa ch\u00e1y\u201d.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_ham_DATEVALUE\"><\/span>S\u1eed d\u1ee5ng\u00a0<strong>h\u00e0m DATEVALUE<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>H\u00e0m DATEVALUE s\u1ebd c\u0103n c\u1ee9 v\u00e0o \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng tr\u00ean m\u00e1y t\u00ednh v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 d\u1ea1ng s\u1ed1 t\u1eeb d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng d\u1ea1ng TEXT.<\/p>\n<p>C\u00e1ch l\u00e0m n\u00e0y c\u00f3 hi\u1ec7u qu\u1ea3 b\u1edfi n\u00f3 s\u1eeda \u0111\u01b0\u1ee3c nhi\u1ec1u d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ed3ng lo\u1ea1t cho nhi\u1ec1u \u00f4.\u00a0<strong>Nh\u01b0ng<\/strong>, \u0111\u1ed1i v\u1edbi d\u1eef li\u1ec7u h\u1ed7n t\u1ea1p, n\u00f3 kh\u00f4ng th\u1ec3 gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c. V\u00ed d\u1ee5:<\/p>\n<figure id=\"attachment_23896\" aria-describedby=\"caption-attachment-23896\" style=\"width: 439px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23896 size-full\" title=\"6- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/date-to-text-or-number-6.png\" alt=\"6- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" width=\"439\" height=\"82\"><figcaption id=\"caption-attachment-23896\" class=\"wp-caption-text\">6- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef<\/figcaption><\/figure>\n<ul>\n<li>\u0110\u1ed1i v\u1edbi \u0111\u1ecbnh d\u1ea1ng chu\u1ea9n Number t\u1eeb \u0111\u1ea7u, h\u00e0m DATEVALUE kh\u00f4ng t\u1ef1 b\u1ecf qua m\u00e0 hi\u1ec3n th\u1ecb #VALUE!<\/li>\n<li>\u0110\u1ed1i v\u1edbi \u0111\u1ecbnh d\u1ea1ng Text b\u1edfi\u00a0<em>vi\u1ebft sai \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m<\/em>, h\u00e0m DATEVALUE c\u0169ng kh\u00f4ng t\u1ef1 s\u1eeda \u0111\u01b0\u1ee3c.<\/li>\n<\/ul>\n<blockquote>\n<p>\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m c\u1ee7a m\u1ed7i m\u00e1y t\u00ednh \u0111\u01b0\u1ee3c quy \u0111\u1ecbnh kh\u00e1c nhau. C\u00f3 m\u00e1y l\u00e0 th\u00e1ng tr\u01b0\u1edbc ng\u00e0y sau, c\u00f3 m\u00e1y l\u00e0 ng\u00e0y tr\u01b0\u1edbc th\u00e1ng sau. Vi\u1ec7c nh\u1eadp sai \u0111\u1ecbnh d\u1ea1ng s\u1ebd khi\u1ebfn d\u1eef li\u1ec7u chuy\u1ec3n v\u1ec1 Text m\u00e0 h\u00e0m DATEVALUE kh\u00f4ng x\u1eed l\u00fd \u0111\u01b0\u1ee3c. C\u1ee5 th\u1ec3 b\u1ea1n h\u00e3y v\u00e0o\u00a0<strong>Control Panel,<\/strong> ch\u1ecdn\u00a0<strong>Region and Language\u00a0<\/strong>\u0111\u1ec3 xem nh\u00e9!<\/p>\n<\/blockquote>\n<figure id=\"attachment_23897\" aria-describedby=\"caption-attachment-23897\" style=\"width: 469px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23897 size-full\" title=\"7- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/date-to-text-or-number-7.png\" alt=\"7- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" width=\"469\" height=\"543\"><figcaption id=\"caption-attachment-23897\" class=\"wp-caption-text\">7- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef<\/figcaption><\/figure>\n<p>V\u1eady, \u0111\u1ed1i v\u1edbi nh\u1eefng d\u1eef li\u1ec7u sai \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng nh\u01b0 v\u1eady, ta ph\u1ea3i l\u00e0m nh\u01b0 n\u00e0o?<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_Text_to_column\"><\/span>S\u1eed d\u1ee5ng\u00a0<strong>Text to column<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u00a0<\/p>\n<p>B\u01b0\u1edbc 1: Sau khi x\u1eed l\u00ed xong d\u1eef li\u1ec7u b\u1eb1ng h\u00e0m\u00a0<strong>DATEVALUE<\/strong>, h\u00e3y\u00a0<strong>SORT<\/strong> \u0111\u1ec3 nh\u1eefng \u00f4 kh\u00f4ng hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 gom v\u1ec1 m\u1ed9t ch\u1ed7.<\/p>\n<p>B\u01b0\u1edbc 2: Ch\u1ecdn nh\u1eefng \u00f4 \u0111\u00f3.<\/p>\n<p>B\u01b0\u1edbc 3: T\u1ea1i th\u1ebb\u00a0<strong>Data,\u00a0<\/strong>nh\u00f3m\u00a0<strong>Data Tools<\/strong>, ch\u1ecdn\u00a0<strong>Text to column.<\/strong><\/p>\n<figure id=\"attachment_23898\" aria-describedby=\"caption-attachment-23898\" style=\"width: 350px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23898 size-full\" title=\"8- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/date-to-text-or-number-8.png\" alt=\"8- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" width=\"350\" height=\"122\"><figcaption id=\"caption-attachment-23898\" class=\"wp-caption-text\">8- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef<\/figcaption><\/figure>\n<p>B\u01b0\u1edbc 4: Khi h\u1ed9p tho\u1ea1i\u00a0<strong>Text to column\u00a0<\/strong>m\u1edf ra, l\u00e0m theo h\u01b0\u1edbng d\u1eabn sau:<\/p>\n<figure id=\"attachment_23899\" aria-describedby=\"caption-attachment-23899\" style=\"width: 508px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23899 size-full\" title=\"9- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/date-to-text-or-number-9.png\" alt=\"9- chuy\u1ec3n t\u1eeb ng\u00e0y th\u00e1ng v\u1ec1 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef\" width=\"508\" height=\"405\"><figcaption id=\"caption-attachment-23899\" class=\"wp-caption-text\">\u1ea4n next<\/figcaption><\/figure>\n<figure id=\"attachment_25196\" aria-describedby=\"caption-attachment-25196\" style=\"width: 514px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25196\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/date-to-text-or-number-10-1.png\" width=\"514\" height=\"412\" title=\"date-to-text-or-number-10-1\"><figcaption id=\"caption-attachment-25196\" class=\"wp-caption-text\">B\u1ecf ch\u1ecdn to\u00e0n b\u1ed9 r\u1ed3i \u1ea5n Next<\/figcaption><\/figure>\n<figure id=\"attachment_25199\" aria-describedby=\"caption-attachment-25199\" style=\"width: 512px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25199\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/date-to-text-or-number-11-2.png\" width=\"512\" height=\"413\" title=\"date-to-text-or-number-11-2\"><figcaption id=\"caption-attachment-25199\" class=\"wp-caption-text\">Ch\u1ecdn Date, sau \u0111\u00f3 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng \u0111ang b\u1ecb sai (trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 MDY). Ch\u1ecdn \u00f4 v\u00e0 \u1ea5n Finish<\/figcaption><\/figure>\n<p>K\u1ebft qu\u1ea3 \u0111\u1ecbnh d\u1ea1ng \u0111\u00fang t\u01b0\u01a1ng \u1ee9ng s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_Flashfill\"><\/span>S\u1eed d\u1ee5ng Flashfill<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Flashfill l\u00e0 m\u1ed9t ch\u1ee9c n\u0103ng th\u00f4ng minh gi\u00fap m\u00e1y t\u00ednh c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c ch\u00fang ta mu\u1ed1n g\u00ec (t\u1ea5t nhi\u00ean \u1edf m\u1ed9t ch\u1eebng m\u1ef1c nh\u1ea5t \u0111\u1ecbnh).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23903\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/date-to-text-or-number-13.png\" width=\"572\" height=\"122\" title=\"date-to-text-or-number-13\"><\/p>\n<p>V\u00ed d\u1ee5 t\u1ea1i \u0111\u00e2y, t\u1ea5t c\u1ea3 c\u00e1c d\u1eef li\u1ec7u \u0111\u1ec1u b\u1ecb sai \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m. \u1ede \u00f4 b\u00ean c\u1ea1nh \u0111\u1ea7u ti\u00ean, ta nh\u1eadp th\u1ee7 c\u00f4ng b\u1eb1ng tay:<\/p>\n<p><em>13\/07\/2018<\/em><\/p>\n<p>Ta n\u00f3i v\u1edbi Excel r\u1eb1ng: H\u00e3y s\u1eafp x\u1ebfp l\u1ea1i ng\u00e0y th\u00e1ng n\u0103m nh\u01b0 th\u1ebf kia!<\/p>\n<p>V\u00e0 Excel c\u00f3 t\u00ednh \u201ch\u1ecdc h\u1ecfi\u201d.<\/p>\n<p>Sau \u0111\u00f3, ta s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Flashfill b\u1eb1ng c\u00e1ch k\u00e9o th\u1ebb v\u00e0 ch\u1ecdn nh\u01b0 trong h\u00ecnh (<strong>ho\u1eb7c s\u1eed d\u1ee5ng ph\u00edm t\u1eaft Ctrl+E):<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23904\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/date-to-text-or-number-14.png\" width=\"573\" height=\"360\" title=\"date-to-text-or-number-14\"><\/p>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c:<\/p>\n<figure id=\"attachment_23905\" aria-describedby=\"caption-attachment-23905\" style=\"width: 575px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-23905\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/date-to-text-or-number-15.png\" width=\"575\" height=\"165\" title=\"date-to-text-or-number-15\"><figcaption id=\"caption-attachment-23905\" class=\"wp-caption-text\">R\u1ea5t th\u00f4ng minh ph\u1ea3i kh\u00f4ng n\u00e0o?<\/figcaption><\/figure>\n<p>Tuy v\u1eady, \u0111\u00f4i khi Flashfill c\u0169ng c\u00f3 nh\u1ea7m l\u1eabn. Nh\u01b0 n\u00e0y ch\u1eb3ng h\u1ea1n:<\/p>\n<figure id=\"attachment_23906\" aria-describedby=\"caption-attachment-23906\" style=\"width: 383px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-23906\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/date-to-text-or-number-16.png\" width=\"383\" height=\"184\" title=\"date-to-text-or-number-16\"><figcaption id=\"caption-attachment-23906\" class=\"wp-caption-text\">V\u00e0 ta l\u1ea1i ph\u1ea3i t\u00ecm c\u00e1ch x\u1eed l\u00ed kh\u00e1c!<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<p>Qua b\u00e0i vi\u1ebft tr\u00ean, H\u1ecdc Excel Online \u0111\u00e3 h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n m\u1ed9t s\u1ed1 c\u00e1ch chuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng (Date), s\u1ed1 (Number) v\u00e0 ch\u1eef (Text). Kh\u00f4ng ch\u1ec9 v\u1eady, c\u00f2n c\u00f3 nh\u1eefng c\u00e1ch l\u00e0m \u0111\u01a1n gi\u1ea3n v\u00e0 s\u00e1ng t\u1ea1o h\u01a1n \u0111ang ch\u1edd c\u00e1c b\u1ea1n kh\u00e1m ph\u00e1 \u0111\u00f3.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t.<\/p>\n<p><strong>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cach-thay-doi-va-tao-dinh-dang-ngay-thang-mac-dinh-tren-excel.html\">C\u00e1ch \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m<\/a> trong Excel chu\u1ea9n nh\u1ea5t<\/strong><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-71.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9607,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9606","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9606","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=9606"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9606\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9607"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}