{"id":1058,"date":"2024-12-02T04:00:13","date_gmt":"2024-12-02T04:00:13","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-doi-dau-phay-thanh-dau-cham-trong-excel-2003-2007-2010\/"},"modified":"2024-12-02T04:00:13","modified_gmt":"2024-12-02T04:00:13","slug":"huong-dan-cach-doi-dau-phay-thanh-dau-cham-trong-excel-2003-2007-2010","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-doi-dau-phay-thanh-dau-cham-trong-excel-2003-2007-2010\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ed5i d\u1ea5u ph\u1ea9y th\u00e0nh d\u1ea5u ch\u1ea5m trong Excel 2003, 2007, 2010"},"content":{"rendered":"
\n

Ph\u1ea7n m\u1ec1m Excel t\u1ea1o n\u00ean t\u1eeb c\u00e1c l\u1eadp tr\u00ecnh vi\u00ean ng\u01b0\u1eddi M\u1ef9, do \u0111\u00f3\u00a0c\u00e1c s\u1ed1 th\u1eadp ph\u00e2n s\u1eed d\u1ee5ng d\u1ea5u ch\u1ea5m \u0111\u1ec3 chia c\u00e1ch, v\u00e0 d\u1ea5u ph\u1ea9y \u0111\u01b0\u1ee3c d\u00f9ng cho cho s\u1ed1 ph\u1ea7n ng\u00e0n l\u00e0 theo quy chu\u1ea9n c\u1ee7a M\u1ef9. C\u00e1ch hi\u1ec3n th\u1ecb n\u00e0y ho\u00e0n to\u00e0n ng\u01b0\u1ee3c l\u1ea1i v\u1edbi ng\u01b0\u1eddi d\u00f9ng Vi\u1ec7t, v\u1edbi d\u1ea5u ph\u1ea9y cho c\u00e1c s\u1ed1 th\u1eadp ph\u00e2n v\u00e0 d\u1ea5u ch\u1ea5m cho c\u00e1c s\u1ed1 ph\u1ea7n ng\u00e0n, khi\u1ebfn cho nhi\u1ec1u b\u1ea1n c\u1ea3m th\u1ea5y kh\u00f4ng s\u1eed d\u1ee5ng.<\/p>\n

\n

V\u1edbi b\u00e0i vi\u1ebft n\u00e0y, Blog H\u1ecdc Excel online<\/a> s\u1ebd chia s\u1ebb cho c\u00e1c b\u1ea1n c\u00e1ch \u0111i\u1ec1u ch\u1ec9nh l\u1ea1i c\u00e1ch hi\u1ec3n th\u1ecb cho ph\u00f9 h\u1ee3p, ch\u00fang ta s\u1ebd \u0111\u1ed5i d\u1ea5u ph\u1ea9y th\u00e0nh d\u1ea5u ch\u1ea5m trong excel<\/strong> nh\u01b0 sau:<\/p>\n<\/blockquote>\n

\u0110\u1ed5i d\u1ea5u ph\u1ea9y th\u00e0nh d\u1ea5u ch\u1ea5m trong excel B\u01af\u1edaC 1<\/figcaption><\/figure>\n

\u0110\u1ea7u ti\u00ean, ch\u1ecdn Start\/Control Panel<\/strong><\/em>. V\u00e0o m\u1ee5c Clock Language and Region<\/strong><\/p>\n

\u0110\u1ed5i d\u1ea5u ph\u1ea9y th\u00e0nh ch\u1ea5m trong Excel B\u01af\u1edaC 2<\/figcaption><\/figure>\n

Ti\u1ebfp t\u1ee5c ch\u1ecdn v\u00e0o Region and Language<\/strong>\/<\/em>Change the date, time or number format<\/em>.\u00a0<\/strong><\/p>\n

\u0110\u1ed5i d\u1ea5u ph\u1ea9y th\u00e0nh ch\u1ea5m trong excel B\u01af\u1edaC 3<\/figcaption><\/figure>\n

Ngay khi c\u00f3 b\u1ea3ng nh\u1ecf hi\u1ec7n ra, ch\u00fang ta ch\u1ecdn v\u00e0o Additional setting<\/strong><\/p>\n

\u0110\u1ed5i d\u1ea5u ph\u1ea9y th\u00e0nh ch\u1ea5m trong excel B\u01af\u1edaC 4<\/figcaption><\/figure>\n

L\u1eadp t\u1ee9c ta nh\u1eadn \u0111\u01b0\u1ee3c b\u1ea3ng sau:<\/p>\n

\u0110\u1ed5i d\u1ea5u ph\u1ea9y th\u00e0nh d\u1ea5u ch\u1ea5m trong excel B\u01af\u1edaC 5<\/figcaption><\/figure>\n

\u00a0<\/p>\n

Decimal symbol<\/b>: \u0111\u1ecbnh d\u1ea1ng d\u1ea5u ng\u0103n c\u00e1ch s\u1ed1 th\u1eadp ph\u00e2n v\u1edbi m\u1eb7c \u0111\u1ecbnh l\u00e0 d\u1ea5u ch\u1ea5m, ch\u00fang ta\u00a0\u0111\u1ed5i l\u1ea1i th\u00e0nh \u0111\u1ea5u ph\u1ea9y.<\/p>\n

Digit grouping symbol<\/b>: \u0111\u1ecbnh d\u1ea1ng d\u1ea5u ng\u0103n c\u00e1ch s\u1ed1 ph\u1ea7n ngh\u00ecn, tri\u1ec7u ho\u1eb7c t\u1ef7\u2026 v\u1edbi m\u1eb7c \u0111\u1ecbnh l\u00e0 d\u1ea5u ph\u1ea9y, ch\u00fang ta\u00a0\u0111\u1ed5i l\u1ea1i th\u00e0nh d\u1ea5u ch\u1ea5m.<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

List separator<\/b>: \u0111\u1ecbnh d\u1ea1ng d\u1ea5u ng\u0103n c\u00e1ch trong c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 thay \u0111\u1ed5i theo \u00fd th\u00edch\u00a0c\u00e1 nh\u00e2n.<\/p>\n

\u0110\u00e3 c\u00e0i \u0111\u1eb7t sau, ch\u00fang ta ch\u1ecdn Apply\/OK<\/strong>\u00a0\u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/p>\n

Xem th\u00eam: T\u00e0i li\u1ec7u excel c\u01a1 b\u1ea3n<\/span><\/a><\/p>\n

L\u01b0u \u00fd: sau khi thay \u0111\u1ed5i nh\u01b0 h\u01b0\u1edbng d\u1eabn m\u00e0 hi\u1ec3n th\u1ecb v\u1eabn ch\u01b0a \u0111\u01b0\u1ee3c nh\u01b0 mong mu\u1ed1n, ch\u00fang ta c\u1ea7n l\u00e0m m\u1ed9t b\u01b0\u1edbc n\u1eefa. Ri\u00eang v\u1edbi Excel 2003, m\u1edf Microsoft Excel v\u00e0o m\u1ee5c Tool\/Option<\/strong>, ch\u1ecdn Tab International\/ Use System Separator<\/strong> r\u1ed3i \u0111\u1ed5i l\u1ea1i d\u1ea5u. C\u00f2n Excel 2007 tr\u1edf l\u00ean, v\u00e0o m\u1ee5c File (n\u00fat g\u00f3c ph\u1ea3i)\/ Option\/ tab \u00a0Advanced<\/strong>, r\u1ed3i ch\u1ecdn\u00a0Use System Separator<\/strong><\/em>.<\/p>\n

L\u01b0u \u00fd tr\u00ean Excel 2007 tr\u1edf l\u00ean b\u01b0\u1edbc 1<\/figcaption><\/figure>\n
L\u01b0u \u00fd tr\u00ean Excel 2007 tr\u1edf l\u00ean b\u01b0\u1edbc 2<\/figcaption><\/figure>\n

Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang xem thu\u1ed9c kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao c\u1ee7a H\u1ecdc Excel Online<\/a>. Kh\u00f3a h\u1ecdc n\u00e0y cung c\u1ea5p cho b\u1ea1n ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng: v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong excel, \u1ee9ng d\u1ee5ng excel trong c\u00f4ng vi\u1ec7c\u2026 Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc n\u00e0y. H\u00e3y tham gia ngay t\u1ea1i \u0111\u1ecba ch\u1ec9: H\u1ecdc Excel Online<\/a><\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1059,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1058","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\/1058","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=1058"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1058\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1059"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1058"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1058"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1058"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}