{"id":12183,"date":"2025-01-15T07:30:46","date_gmt":"2025-01-15T07:30:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-dinh-dang-so-thanh-phan-so-trong-excel\/"},"modified":"2025-01-15T07:30:46","modified_gmt":"2025-01-15T07:30:46","slug":"huong-dan-dinh-dang-so-thanh-phan-so-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-dinh-dang-so-thanh-phan-so-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn \u0111\u1ecbnh d\u1ea1ng s\u1ed1 th\u00e0nh ph\u00e2n s\u1ed1 trong excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>Ch\u1eafc ch\u1eafn, khi s\u1eed d\u1ee5ng Excel, s\u1ebd c\u00f3 nhi\u1ec1u b\u1ea1n g\u1eb7p ph\u1ea3i v\u1ea5n \u0111\u1ec1 l\u00e0 g\u00f5 kh\u00f4ng \u0111\u01b0\u1ee3c d\u1ea1ng ph\u00e2n s\u1ed1. \u0110a s\u1ed1 th\u01b0\u1eddng d\u1ec5 b\u1ecb m\u1eafc l\u1ed7i l\u00e0 g\u00f5 ph\u00e2n s\u1ed1 nh\u01b0ng l\u1ea1i hi\u1ec3n th\u1ecb ra ng\u00e0y th\u00e1ng.\u00a0<\/strong><\/em><\/p>\n<figure id=\"attachment_3828\" aria-describedby=\"caption-attachment-3828\" style=\"width: 302px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3828 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1.png\" width=\"302\" height=\"170\" title=\"1\"><figcaption id=\"caption-attachment-3828\" class=\"wp-caption-text\">Nh\u1eadp ph\u00e2n s\u1ed1 3\/4 nh\u01b0ng k\u1ebft qu\u1ea3 l\u1ea1i l\u00e0 ng\u00e0y 4 th\u00e1ng 3.<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><em><strong>V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 g\u00f5 d\u1ea1ng ph\u00e2n s\u1ed1 \u0111\u00fang \u0111\u00e2y?<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">D\u01b0\u1edbi \u0111\u00e2y, m\u00ecnh s\u1ebd chia s\u1ebd cho c\u00e1c b\u1ea1n h\u01b0\u1edbng d\u1eabn chi ti\u1ebft v\u1ec1 th\u1ee7 thu\u1eadt n\u00e0y.<\/p>\n<p style=\"text-align: justify\">Cho b\u1ea3ng s\u1ed1 li\u1ec7u sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3831 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-1.png\" width=\"600\" height=\"416\" title=\"1-1\"><\/p>\n<ul style=\"text-align: justify\">\n<li style=\"text-align: justify\">Mu\u1ed1n c\u00f3 d\u1ea1ng ph\u00e2n s\u1ed1, b\u00f4i \u0111en v\u00f9ng mu\u1ed1n hi\u1ec3n th\u1ecb ph\u00e2n s\u1ed1, nh\u1ea5p chu\u1ed9t ph\u1ea3i ch\u1ecdn\u00a0<b>Format Cells.<\/b><\/li>\n<li style=\"text-align: justify\">Ch\u1ecdn m\u1ee5c\u00a0<b>Fraction -&gt; Up to one digit (1\/4)<\/b><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3832 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-2.png\" width=\"600\" height=\"313\" title=\"1-2\"><\/p>\n<p style=\"text-align: justify\">=&gt; Khi \u0111\u00f3 Excel s\u1ebd hi\u1ec3n th\u1ecb \u0111\u00fang d\u1ea1ng ph\u00e2n s\u1ed1.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3833 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-3.png\" width=\"600\" height=\"413\" title=\"1-3\"><\/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-364.gif\" title=\"ex101_92019-nho-364\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">* Tuy nhi\u00ean, c\u00f3 tr\u01b0\u1eddng h\u1ee3p n\u1ebfu T\u1eed s\u1ed1 l\u1edbn h\u01a1n s\u1ebd v\u1eabn hi\u1ec3n th\u1ecb d\u1ea1ng chu\u1ed7i, kh\u00f4ng ph\u1ea3i l\u00e0 ph\u00e2n s\u1ed1, ta ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o?<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3834 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-4.png\" width=\"452\" height=\"270\" title=\"1-4\"><\/p>\n<ul style=\"text-align: justify\">\n<li style=\"text-align: justify\">B\u00f4i \u0111en v\u00f9ng ch\u1ecdn, nh\u1ea5p chu\u1ed9t ph\u1ea3i ch\u1ecdn <strong>Format Cells =&gt;<\/strong>\u00a0V\u00e0o <strong>Custom.<\/strong><\/li>\n<li style=\"text-align: justify\">Trong khung Type, b\u1ea1n g\u00f5 \u201c<strong>#???\/???\u201d, <\/strong>r\u1ed3i\u00a0nh\u1ea5n OK. (D\u1ea5u ch\u1ea5m h\u1ecfi \u201c<strong>?<\/strong>\u201d t\u01b0\u01a1ng \u1ee9ng v\u1edbi 1 ch\u1eef s\u1ed1, c\u00f3 th\u1ec3 ch\u1ecdn tu\u1ef3 \u00fd s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a n\u00f3)<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3836 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-5.png\" width=\"600\" height=\"360\" title=\"1-5\"><\/p>\n<p style=\"text-align: justify\">=&gt; K\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3837 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-6.png\" width=\"454\" height=\"273\" title=\"1-6\"><\/p>\n<p>\u00a0<\/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-364.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12184,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12183","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\/12183","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=12183"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12183\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12184"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}