{"id":5258,"date":"2024-12-10T06:39:32","date_gmt":"2024-12-10T06:39:32","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/huong-dan-thay-doi-thiet-lap-phan-thap-phan-dinh-dang-so-trong-excel-bang-dau-cham\/"},"modified":"2024-12-10T06:39:32","modified_gmt":"2024-12-10T06:39:32","slug":"huong-dan-thay-doi-thiet-lap-phan-thap-phan-dinh-dang-so-trong-excel-bang-dau-cham","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/huong-dan-thay-doi-thiet-lap-phan-thap-phan-dinh-dang-so-trong-excel-bang-dau-cham\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn thay \u0111\u1ed5i thi\u1ebft l\u1eadp ph\u1ea7n th\u1eadp ph\u00e2n \u2013 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel b\u1eb1ng d\u1ea5u ch\u1ea5m"},"content":{"rendered":"
\n

Trong Excel, theo m\u1eb7c \u0111\u1ecbnh c\u1ee7a m\u00e1y ta c\u00f3 quy \u0111\u1ecbnh v\u1ec1 d\u1ea5u ch\u1ea5m v\u00e0 d\u1ea5u ph\u1ea9y. \u0110\u1ec3 t\u00f9y ch\u1ec9nh t\u01b0\u01a1ng \u1ee9ng c\u00e1c tr\u01b0\u1eddng h\u1ee3p, h\u00e3y tham kh\u1ea3o b\u00e0i vi\u1ebft sau \u0111\u00e2y c\u1ee7a H\u1ecdc Excel Online<\/strong><\/a>: Thay \u0111\u1ed5i thi\u1ebft l\u1eadp ph\u1ea7n th\u1eadp ph\u00e2n \u2013 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel b\u1eb1ng d\u1ea5u ch\u1ea5m.<\/p>\n

\u0110\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel b\u1eb1ng d\u1ea5u ch\u1ea5m<\/h2>\n

Th\u00f4ng th\u01b0\u1eddng, Excel quy \u0111\u1ecbnh d\u1ea5u ph\u1ea9y s\u1eed d\u1ee5ng \u0111\u1ec3 bi\u1ec3u th\u1ecb ng\u0103n c\u00e1ch ph\u1ea7n ngh\u00ecn v\u00e0 d\u1ea5u ch\u1ea5m cho ph\u1ea7n tr\u0103m.<\/p>\n

<\/p>\n

Tuy nhi\u00ean, \u0111\u1ed1i v\u1edbi c\u00e1ch \u0111\u1ecdc th\u00f4ng th\u01b0\u1eddng \u1edf Vi\u1ec7t Nam, c\u00f3 l\u1ebd ta c\u1ea7n ph\u1ea3i \u0111\u1ea3o d\u1ea5u khi \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 \u201cthu\u1eadn tai, thu\u1eadn m\u1eaft\u201d h\u01a1n. Cho n\u00ean ch\u00fang ta c\u1ea7n ph\u1ea3i chuy\u1ec3n \u0111\u1ed5i d\u1ea5u ch\u1ea5m v\u00e0 ph\u1ea9y trong excel, c\u1ee5 th\u1ec3 l\u00e0 chuy\u1ec3n d\u1ea5u ch\u1ea5m th\u00e0nh d\u1ea5u ph\u1ea9y trong excel v\u00e0 ng\u01b0\u1ee3c l\u1ea1i c\u00e1ch chuy\u1ec3n d\u1ea5u ph\u1ea9y th\u00e0nh d\u1ea5u ch\u1ea5m trong Excel<\/p>\n

\u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c vi\u1ec7c n\u00e0y, \u0111\u1ea7u ti\u00ean ta v\u00e0o\u00a0File<\/strong><\/p>\n

<\/p>\n

Ti\u1ebfp theo ta ch\u1ecdn Options<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i\u00a0Excel Options.\u00a0<\/strong>Trong \u0111\u00f3, ch\u1ecdn th\u1ebb\u00a0Advanced.\u00a0<\/strong>T\u1ea1i \u0111\u00e2y b\u1ea1n s\u1ebd th\u1ea5y \u0111\u01b0\u1ee3c d\u1ea5u m\u1eb7c \u0111\u1ecbnh c\u1ee7a h\u1ec7 th\u1ed1ng (trong h\u00ecnh).<\/p>\n

<\/p>\n

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

Vi\u1ec7c ta c\u1ea7n l\u00e0m l\u00e0 b\u1ecf d\u1ea5u t\u00edch c\u1ee7a \u201cuse system separators\u201d, sau \u0111\u00f3 chuy\u1ec3n\u00a0Decimal separator\u00a0<\/strong>v\u1ec1 d\u1ea5u\u00a0ph\u1ea9y<\/strong>,\u00a0Thousands separator<\/strong> v\u1ec1 d\u1ea5u\u00a0ch\u1ea5m.<\/strong><\/p>\n

<\/p>\n

Ta thu \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 h\u00ecnh. \u0110\u00f3 l\u00e0 to\u00e0n b\u1ed9 c\u00e1ch chuy\u1ec3n d\u1ea5u ch\u1ea5m th\u00e0nh d\u1ea5u ph\u1ea9y trong excel v\u00e0 ng\u01b0\u1ee3c l\u1ea1i chuy\u1ec3n d\u1ea5u ph\u1ea9y th\u00e0nh d\u1ea5u ch\u1ea5m trong excel.<\/p>\n

\n

Ngo\u00e0i ra, n\u1ebfu b\u1ea1n quan t\u00e2m \u0111\u1ebfn c\u00e1c d\u1ea5u ng\u0103n c\u00e1ch, c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft sau:<\/p>\n

Thay \u0111\u1ed5i c\u00e1c d\u1ea5u ng\u0103n c\u00e1ch trong Excel<\/a><\/strong><\/p>\n

Chuy\u1ec3n \u0111\u1ed5i d\u1ea5u ng\u0103n c\u00e1ch<\/a><\/strong><\/p>\n

\u00a0<\/p>\n

Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t<\/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":5259,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5258","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\/5258","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=5258"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5258\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5259"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5258"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}