{"id":5774,"date":"2024-12-20T20:35:25","date_gmt":"2024-12-20T20:35:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/20\/huong-dan-thay-doi-cac-dau-ngan-cach-trong-excel\/"},"modified":"2024-12-20T20:35:25","modified_gmt":"2024-12-20T20:35:25","slug":"huong-dan-thay-doi-cac-dau-ngan-cach-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/20\/huong-dan-thay-doi-cac-dau-ngan-cach-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn thay \u0111\u1ed5i c\u00e1c d\u1ea5u ng\u0103n c\u00e1ch trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>\u0110\u00e3 bao gi\u1edd b\u1ea1n th\u1ea5y s\u1ef1 kh\u00e1c bi\u1ec7t c\u1ee7a c\u00e1c d\u1ea5u ng\u0103n c\u00e1ch gi\u1eefa c\u00e1c phi\u00ean b\u1ea3n trong Excel ch\u01b0a? N\u1ebfu v\u1eabn c\u00f2n th\u1eafc m\u1eafc nguy\u00ean nh\u00e2n, h\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft sau \u0111\u00e2y c\u1ee7a H\u1ecdc Excel Online: H\u01b0\u1edbng d\u1eabn thay \u0111\u1ed5i c\u00e1c d\u1ea5u ng\u0103n c\u00e1ch trong Excel.<\/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-6765d50c264b2\" 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\/thay-doi-cac-dau-ngan-cach-trong-excel.html#Thay_doi_cac_dau_ngan_cach_phan_nghin_va_ngan_cach_phan_thap_phan\" title=\"Thay \u0111\u1ed5i c\u00e1c d\u1ea5u ng\u0103n c\u00e1ch ph\u1ea7n ngh\u00ecn v\u00e0 ng\u0103n c\u00e1ch ph\u1ea7n th\u1eadp ph\u00e2n\">Thay \u0111\u1ed5i c\u00e1c d\u1ea5u ng\u0103n c\u00e1ch ph\u1ea7n ngh\u00ecn v\u00e0 ng\u0103n c\u00e1ch ph\u1ea7n th\u1eadp ph\u00e2n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/thay-doi-cac-dau-ngan-cach-trong-excel.html#Thay_doi_dau_ngan_cach_cac_doi_tuong_trong_cong_thuc\" title=\"Thay \u0111\u1ed5i d\u1ea5u ng\u0103n c\u00e1ch c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng trong c\u00f4ng th\u1ee9c\">Thay \u0111\u1ed5i d\u1ea5u ng\u0103n c\u00e1ch c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng trong c\u00f4ng th\u1ee9c<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Thay_doi_cac_dau_ngan_cach_phan_nghin_va_ngan_cach_phan_thap_phan\"><\/span>Thay \u0111\u1ed5i c\u00e1c d\u1ea5u ng\u0103n c\u00e1ch ph\u1ea7n ngh\u00ecn v\u00e0 ng\u0103n c\u00e1ch ph\u1ea7n th\u1eadp ph\u00e2n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1ec1 m\u1eb7c \u0111\u1ecbnh, khi ta nh\u1eadp v\u00e0o m\u1ed9t s\u1ed1 v\u00e0 \u0111\u1ecbnh d\u1ea1ng, ph\u1ea7n ngh\u00ecn s\u1ebd \u0111\u01b0\u1ee3c ng\u0103n c\u00e1ch b\u1edfi\u00a0<strong>d\u1ea5u ph\u1ea9y (,)<\/strong>, ph\u1ea7n th\u1eadp ph\u00e2n s\u1ebd \u0111\u01b0\u1ee3c ng\u0103n c\u00e1ch b\u1eb1ng\u00a0<strong>d\u1ea5u ch\u1ea5m (.).<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23748\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doi-dau-1.png\" width=\"616\" height=\"146\" title=\"doi-dau-1\"><\/p>\n<p>Ta c\u00f3 th\u1ec3 thay \u0111\u1ed5i nh\u1eefng d\u1ea5u n\u00e0y nh\u01b0 th\u1ebf n\u00e0o?<\/p>\n<p>\u0110\u1ea7u ti\u00ean, ch\u1ecdn th\u1ebb\u00a0<strong>File<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23749\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doi-dau-2.png\" width=\"368\" height=\"201\" title=\"doi-dau-2\"><\/p>\n<p>Sau \u0111\u00f3, ch\u1ecdn\u00a0<strong>Options<\/strong><\/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\/2024\/12\/ex101_92019-nho-506.gif\" title=\"ex101_92019-nho-506\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23750\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doi-dau-3.png\" width=\"731\" height=\"576\" title=\"doi-dau-3\"><\/p>\n<p>Khi h\u1ed9p tho\u1ea1i Excel Options \u0111\u01b0\u1ee3c m\u1edf ra, ch\u1ecdn m\u1ee5c\u00a0<strong>Advanced\u00a0<\/strong>v\u00e0 b\u1ecf ch\u1ecdn \u00f4\u00a0<strong>Use systems separators<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23751\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doi-dau-4.png\" width=\"836\" height=\"677\" title=\"doi-dau-4\"><\/p>\n<p>Sau \u0111\u00f3 ta c\u00f3 th\u1ec3 thay c\u00e1c d\u1ea5u theo \u00fd mu\u1ed1n. V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y \u0111\u00e3 \u0111\u1ea3o ng\u01b0\u1ee3c d\u1ea5u:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23754\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doi-dau-5.png\" width=\"218\" height=\"82\" title=\"doi-dau-5\"><\/p>\n<p>V\u00e0 k\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23756\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doi-dau-6.png\" width=\"621\" height=\"149\" title=\"doi-dau-6\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thay_doi_dau_ngan_cach_cac_doi_tuong_trong_cong_thuc\"><\/span>Thay \u0111\u1ed5i d\u1ea5u ng\u0103n c\u00e1ch c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng trong c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e2u h\u1ecfi th\u1ee9 hai c\u1ee7a nhi\u1ec1u ng\u01b0\u1eddi v\u1ec1 d\u1ea5u, \u0111\u00f3 l\u00e0 s\u1ef1 kh\u00e1c bi\u1ec7t khi vi\u1ebft c\u00f4ng th\u1ee9c. T\u1ea1i sao c\u00f3 m\u00e1y l\u1ea1i s\u1eed d\u1ee5ng d\u1ea5u ph\u1ea9y, trong khi m\u00e1y kh\u00e1c l\u00e0 ch\u1ea5m ph\u1ea9y?<\/p>\n<p><strong>Nguy\u00ean nh\u00e2n:\u00a0<\/strong><em>Do q<\/em><em>uy \u0111\u1ecbnh bi\u1ec3u di\u1ec5n d\u1ea5u m\u1eb7c \u0111\u1ecbnh trong m\u00e1y m\u1ed7i ng\u01b0\u1eddi kh\u00e1c nhau m\u00e0 h\u00ecnh th\u00e0nh d\u1ea5u ph\u1ea9y ho\u1eb7c ch\u1ea5m ph\u1ea9y.<\/em><\/p>\n<p>C\u00e1ch gi\u1ea3i quy\u1ebft:<\/p>\n<p><strong>B\u01b0\u1edbc 1:\u00a0<\/strong>V\u00e0o Control Panel tr\u00ean m\u00e1y t\u00ednh<\/p>\n<p><strong>B\u01b0\u1edbc 2:\u00a0<\/strong>T\u00ecm \u0111\u1ebfn m\u1ee5c \u201c<strong>Regional and language\u201d<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 3:\u00a0<\/strong>T\u1ea1i th\u1ebb\u00a0<strong>Formats<\/strong>, ch\u1ecdn\u00a0<strong>Additional Settings\u2026<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 4:\u00a0<\/strong>T\u1ea1i th\u1ebb\u00a0<strong>Numbers<\/strong>, ch\u1ec9nh s\u1eeda <strong>Decimal Symbol<\/strong> &amp; <strong>Digit grouping symbol<\/strong>.<\/p>\n<p>\u00a0<\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong><\/p>\n<p><em>\u0110\u1ed1i v\u1edbi \u0111\u1ed5i d\u1ea5u h\u00e0ng ngh\u00ecn v\u00e0 ph\u1ea7n th\u1eadp ph\u00e2n, ta c\u00f3 th\u1ec3 \u0111\u1ed5i d\u1ea5u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng\u00a0<strong>Region and Language<\/strong> t\u01b0\u01a1ng t\u1ef1 v\u1edbi \u0111\u1ed5i d\u1ea5u ng\u0103n c\u00e1ch c\u00f4ng th\u1ee9c. Tuy nhi\u00ean b\u1edfi n\u00f3 can thi\u1ec7p v\u00e0o d\u1ea5u c\u1ee7a h\u1ec7 th\u1ed1ng, c\u00f3 th\u1ec3 d\u1eabn t\u1edbi m\u1ed9t s\u1ed1 thay \u0111\u1ed5i c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh kh\u00e1c b\u1edfi v\u1eady ch\u00fang ta ch\u1ec9 n\u00ean thay \u0111\u1ed5i trong m\u00f4i tr\u01b0\u1eddng Excel.<\/em><\/p>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 vi\u1ec7c thay \u0111\u1ed5i c\u00e1c d\u1ea5u ng\u0103n c\u00e1ch trong Excel.<\/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\/huong-dan-cach-doi-dau-phay-thanh-dau-cham-trong-excel-2003-2007-2010.html\">\u0110\u1ed5i d\u1ea5u ph\u1ea9y th\u00e0nh d\u1ea5u ch\u1ea5m trong excel<\/a> d\u1ec5 d\u00e0ng<\/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\/2024\/12\/ex101_92019-nho-506.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5775,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5774","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\/5774","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=5774"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5774\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5775"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}