{"id":8641,"date":"2021-08-23T18:44:23","date_gmt":"2021-08-23T11:44:23","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=8641"},"modified":"2021-08-23T18:44:23","modified_gmt":"2021-08-23T11:44:23","slug":"chuyen-ngay-thang-nam-sang-dang-text-chuan","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/chuyen-ngay-thang-nam-sang-dang-text-chuan\/","title":{"rendered":"Chuy\u1ec3n ng\u00e0y th\u00e1ng n\u0103m sang d\u1ea1ng Text chu\u1ea9n"},"content":{"rendered":"

1. \u0110\u1ecbnh d\u1ea1ng b\u1eb1ng Control Panel<\/strong><\/h3>\n

V\u1edbi c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng Control Panel, ch\u00fang t\u00f4i khuy\u00ean b\u1ea1n n\u00ean h\u1ea1n ch\u1ebf s\u1eed d\u1ee5ng v\u00ec n\u00f3 s\u1ebd thay \u0111\u1ed5i ho\u00e0n to\u00e0n \u0111\u1ecbnh d\u1ea1ng c\u1ee7a m\u00e1y v\u00e0 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, Excel c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng. C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

B\u01b0\u1edbc 1<\/strong>: Tr\u00ean b\u00e0n ph\u00edm c\u1ee7a m\u00e1y t\u00ednh, b\u1ea1n \u1ea5n t\u1ed5 h\u1ee3p ph\u00edm\u00a0Windows +R<\/strong><\/p>\n

\"C\u00e1ch<\/strong><\/p>\n

B\u01b0\u1edbc 2:<\/strong>Sau khi \u1ea5n t\u1ed5 h\u1ee3p ph\u00edm, h\u1ed9i tho\u1ea1i Run \u0111\u01b0\u1ee3c m\u1edf ra, b\u1ea1n ti\u1ebfp t\u1ee5c nh\u1eadp\u201cControl\u201d<\/strong>\u00a0v\u00e0o \u00f4 Open. Sau \u0111\u00f3 \u1ea5n\u00a0OK.<\/strong><\/p>\n

\"C\u00e1ch<\/strong><\/p>\n

B\u01b0\u1edbc 3:<\/strong>\u00a0Trong c\u1eeda s\u1ed5\u00a0Control Panel<\/strong>, b\u1ea1n ch\u1ecdn\u00a0Category<\/strong>\u00a0trong danh m\u1ee5c\u201cView by\u201d,<\/strong>\u00a0sau \u0111\u00f3 ch\u1ecdn d\u00f2ng\u201cChange Date, Time, or Number Formats\u201d.<\/strong><\/p>\n

\"C\u00e1ch<\/p>\n

B\u01b0\u1edbc 4:<\/strong>\u00a0Trong b\u1ea3ng Region, m\u00e1y ch\u1ee7 s\u1ebd cung c\u1ea5p c\u00e1c \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng l\u1ef1a ch\u1ecdn nh\u01b0 sau:<\/p>\n

TrongFormat<\/strong>\u00a0-> ch\u1ecdn\u00a0Vietnamese<\/strong><\/p>\n

Trong\u00a0Date and time formats<\/strong>\u00a0ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng nh\u01b0 h\u00ecnh m\u00e0 ch\u00fang t\u00f4i cung c\u1ea5p ph\u00eda d\u01b0\u1edbi.<\/p>\n

Trong \u0111\u00f3<\/p>\n

– Short Date: Bi\u1ec3u th\u1ecb ng\u00e0y ng\u1eafn<\/p>\n

– Long Date: Bi\u1ec3u th\u1ecb ng\u00e0y d\u00e0i<\/p>\n

– Short Time: Bi\u1ec3u th\u1ecb gi\u1edd ng\u1eafn<\/p>\n

– Long Time: Bi\u1ec3u th\u1ecb gi\u1edd d\u00e0i.<\/p>\n

– First day of week: ng\u00e0y \u0111\u1ea7u ti\u00ean trong tu\u1ea7n<\/p>\n

Sau khi \u0111\u00e3 ho\u00e0n th\u00e0nh xong c\u00e1c m\u1ee5c, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u1ea7n Exemples \u0111\u1ec3 c\u00f3 th\u1ec3 xem tr\u01b0\u1edbc c\u00e1c \u0111\u1ecbnh d\u1ea1ng.<\/p>\n

\"C\u00e1ch<\/p>\n

B\u01b0\u1edbc 5:<\/strong>Ti\u1ebfp t\u1ee5c \u1ea5n\u00a0Ok <\/strong>l\u00e0 b\u1ea1n \u0111\u00e3 ho\u00e0n th\u00e0nh c\u00e1c thao t\u00e1c th\u1ef1c hi\u1ec7n.<\/p>\n

\"C\u00e1ch<\/p>\n

\n

2. C\u00e1ch chuy\u1ec3n ng\u00e0y th\u00e1ng n\u0103m sang d\u1ea1ng Text b\u1eb1ng Format Cells<\/strong><\/h3>\n

Khi s\u1eed d\u1ee5ng Format Cell, b\u1ea1n ch\u1ec9 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng trong m\u1ed9t \u00f4 d\u1eef li\u1ec7u c\u1ee7a Excel m\u00e0 kh\u00f4ng h\u1ec1 b\u1ecb \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn \u0111\u1ecbnh d\u1ea1ng chung c\u1ee7a m\u00e1y. C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

B\u01b0\u1edbc 1:<\/strong>M\u1edf File Excel v\u00e0 ch\u1ecdn \u00f4 d\u1eef li\u1ec7u c\u00f3 ch\u1ee9a \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng -> nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn\u00a0Format Cells.<\/strong><\/p>\n

\"C\u00e1ch<\/strong><\/p>\n

B\u01b0\u1edbc 2<\/strong>: Trong h\u1ed9p tho\u1ea1i\u00a0Format Cells<\/strong>, trong m\u1ee5c\u00a0Number,<\/strong> b\u1ea1n ch\u1ecdn\u00a0Date <\/strong>v\u00e0 ch\u1ecdn theo \u0111\u1ecbnh d\u1ea1ng v\u00e0 m\u00ecnh mu\u1ed1n chuy\u1ec3n. Sau \u0111\u00f3 \u1ea5n OK<\/strong>\u00a0l\u00e0 b\u1ea1n \u0111\u00e3 ho\u00e0n th\u00e0nh.<\/p>\n

\"C\u00e1ch<\/p>\n

\"C\u00e1ch<\/p>\n

3. Chuy\u1ec3n \u0111\u1ecbnh d\u1ea1ng s\u1ed1 th\u00e0nh d\u1eef li\u1ec7u v\u0103n b\u1ea3n<\/strong><\/h3>\n

Vi\u1ec7c chuy\u1ec3n \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng n\u0103m d\u1ea1ng s\u1ed1 sang d\u1eef li\u1ec7u v\u0103n b\u1ea3n c\u00f3 th\u1ec3 gi\u00fap ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0a v\u00e0o c\u00e1c c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh to\u00e1n m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. Thao t\u00e1c th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

B\u01b0\u1edbc 1<\/strong>: Ki\u1ec3m tra \u00f4 d\u1eef li\u1ec7u v\u00e0o c\u00e1ch ch\u1ecdn Date tr\u00ean thanh c\u00f4ng c\u1ee5 nh\u01b0 m\u00f4 t\u1ea3 d\u01b0\u1edbi h\u00ecnh.<\/p>\n

\"C\u00e1ch<\/p>\n

B\u01b0\u1edbc 2:<\/strong>Trong File c\u1ea7n ch\u1ecdn d\u1eef li\u1ec7u, b\u1ea1n ch\u1ecdn \u00f4 b\u1ea5t k\u1ef3 v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c nh\u01b0 sau:=Text(Value;format_text)<\/strong>. Trong \u0111\u00f3,<\/p>\n

– Value: mang \u00fd ngh\u0129a l\u00e0 \u00f4 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i.<\/p>\n

– Format_Text: \u0111\u1ecbnh d\u1ea1ng m\u00e0 ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n s\u1eed d\u1ee5ng \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i.<\/p>\n

\"C\u00e1ch<\/p>\n

VD1: Ch\u00fang ta c\u00f3 d\u1eef li\u1ec7u 03\/12\/2000 t\u1ea1i c\u1ed9t B1. B\u1ea1n nh\u1eadp h\u00e0m: Text(B1;”dd.mm.yyyy”) l\u00e0 cho ra k\u1ebft qu\u1ea3 03.12.2000.<\/em><\/p>\n

\"C\u00e1ch<\/em><\/p>\n

Nh\u1eadp h\u00e0m: Text(B1;”dd.mm.yyyy”)<\/em><\/p>\n

\"C\u00e1ch<\/em><\/p>\n

K\u1ebft qu\u1ea3: 03.12.2000<\/em><\/p>\n

VD2: Ch\u00fang ta c\u00f3 d\u1eef li\u1ec7u 03\/12\/2000 t\u1ea1i c\u1ed9t B1. B\u1ea1n nh\u1eadp h\u00e0m: Text(B1;”dd-mm-yyyy”) l\u00e0 cho ra k\u1ebft qu\u1ea3 03-12-2000.<\/em><\/p>\n

\"C\u00e1ch<\/em><\/p>\n

Nh\u1eadp h\u00e0m: Text(B1;”dd-mm-yyyy”)<\/em><\/p>\n

\"C\u00e1ch<\/p>\n

K\u1ebft qu\u1ea3: 03-12-2000<\/em><\/p>\n

Nh\u01b0 v\u1eady th\u00f4ng qua b\u00e0i vi\u1ebft tr\u00ean,\u00a0 b\u1ea1n th\u1ea5y c\u00e1ch chuy\u1ec3n ng\u00e0y th\u00e1ng n\u0103m sang d\u1ea1ng Text v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n ch\u01b0a!<\/p>\n

Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng..<\/p>\n","protected":false},"excerpt":{"rendered":"

1. \u0110\u1ecbnh d\u1ea1ng b\u1eb1ng Control Panel V\u1edbi c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng Control Panel, ch\u00fang t\u00f4i khuy\u00ean b\u1ea1n n\u00ean h\u1ea1n ch\u1ebf s\u1eed d\u1ee5ng v\u00ec n\u00f3 s\u1ebd thay \u0111\u1ed5i ho\u00e0n to\u00e0n \u0111\u1ecbnh d\u1ea1ng c\u1ee7a m\u00e1y v\u00e0 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, Excel c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng. C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau: B\u01b0\u1edbc 1: Tr\u00ean b\u00e0n […]<\/p>\n","protected":false},"author":3,"featured_media":8642,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-8641","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tin-tuc"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=8641"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8641\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/8642"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=8641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=8641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=8641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}