{"id":2365,"date":"2025-10-15T14:38:44","date_gmt":"2025-10-15T07:38:44","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-them-so-0-o-dau-trong-excel-huong-dan-chi-tiet\/"},"modified":"2025-10-15T14:38:44","modified_gmt":"2025-10-15T07:38:44","slug":"cach-them-so-0-o-dau-trong-excel-huong-dan-chi-tiet","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-them-so-0-o-dau-trong-excel-huong-dan-chi-tiet\/","title":{"rendered":"C\u00e1ch th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u trong Excel: H\u01b0\u1edbng d\u1eabn chi ti\u1ebft"},"content":{"rendered":"
\n

B\u1ea1n \u0111\u00e3 bao gi\u1edd g\u1eb7p t\u00ecnh hu\u1ed1ng g\u00f5 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i ho\u1eb7c s\u1ed1 CCCD v\u00e0o Excel, nh\u01b0ng s\u1ed1 0 \u1edf \u0111\u1ea7u b\u1ed7ng nhi\u00ean bi\u1ebfn m\u1ea5t? \u0110\u1eebng lo l\u1eafng! \u0110\u00e2y l\u00e0 v\u1ea5n \u0111\u1ec1 ph\u1ed5 bi\u1ebfn khi l\u00e0m vi\u1ec7c v\u1edbi Excel nh\u01b0ng b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c d\u1ec5 d\u00e0ng. Trong b\u00e0i vi\u1ebft n\u00e0y, Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u trong Excel v\u1edbi c\u00e1c ph\u01b0\u01a1ng ph\u00e1p \u0111\u01a1n gi\u1ea3n, gi\u00fap d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n hi\u1ec3n th\u1ecb \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng mong mu\u1ed1n.<\/p>\n

\"H\u01b0\u1edbng<\/em><\/p>\n

C\u00e1ch th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u trong Excel<\/em><\/p>\n

\n

1. C\u00e1ch th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u trong Excel b\u1eb1ng d\u1ea5u nh\u00e1y \u0111\u01a1n<\/h2>\n<\/div>\n

M\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u l\u00e0 s\u1eed d\u1ee5ng d\u1ea5u nh\u00e1y \u0111\u01a1n (‘). C\u00e1ch n\u00e0y ph\u00f9 h\u1ee3p khi b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u th\u1ee7 c\u00f4ng.<\/p>\n

B\u01b0\u1edbc 1: <\/strong>Nh\u1ea5p v\u00e0o \u00f4 Excel m\u00e0 b\u1ea1n mu\u1ed1n nh\u1eadp s\u1ed1.<\/p>\n

B\u01b0\u1edbc 2: <\/strong>G\u00f5 d\u1ea5u nh\u00e1y \u0111\u01a1n (‘) tr\u01b0\u1edbc s\u1ed1 0, v\u00ed d\u1ee5: ‘01234. Cu\u1ed1i c\u00f9ng nh\u1ea5n Enter, Excel s\u1ebd hi\u1ec3n th\u1ecb s\u1ed1 01234 m\u00e0 kh\u00f4ng b\u1ecf s\u1ed1 0.<\/p>\n

\"H\u01b0\u1edbng<\/em><\/p>\n

C\u00e1ch th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u trong Excel b\u1eb1ng d\u1ea5u nh\u00e1y \u0111\u01a1n<\/em><\/p>\n

L\u01b0u \u00fd: <\/strong>D\u1ea5u nh\u00e1y \u0111\u01a1n s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb trong \u00f4, nh\u01b0ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u01b0u d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n.<\/em><\/p>\n

\n

2. C\u00e1ch th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u trong Excel b\u1eb1ng s\u1eed d\u1ee5ng h\u00e0m<\/h2>\n<\/div>\n

N\u1ebfu b\u1ea1n c\u1ea7n th\u00eam s\u1ed1 0 cho nhi\u1ec1u \u00f4 d\u1eef li\u1ec7u, s\u1eed d\u1ee5ng h\u00e0m Excel l\u00e0 l\u1ef1a ch\u1ecdn hi\u1ec7u qu\u1ea3. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 hai h\u00e0m ph\u1ed5 bi\u1ebfn:<\/p>\n

\n

S\u1eed d\u1ee5ng h\u00e0m TEXT<\/h3>\n<\/div>\n

H\u00e0m TEXT cho ph\u00e9p \u0111\u1ecbnh d\u1ea1ng s\u1ed1 v\u1edbi s\u1ed1 0 \u1edf \u0111\u1ea7u theo s\u1ed1 ch\u1eef s\u1ed1 b\u1ea1n mu\u1ed1n.<\/p>\n

C\u00fa ph\u00e1p:<\/strong> =TEXT(value, Format)<\/p>\n

    \n
  • value:<\/strong><\/em> \u00d4 ch\u1ee9a s\u1ed1 c\u1ea7n th\u00eam 0.<\/li>\n
  • Format: <\/strong><\/em>\u0110\u1ecbnh d\u1ea1ng s\u1ed1 ch\u1eef s\u1ed1, v\u00ed d\u1ee5 5 ch\u1eef s\u1ed1 s\u1ebd th\u00eam s\u1ed1 0 \u0111\u1ec3 \u0111\u1ee7 5.<\/li>\n<\/ul>\n

    V\u00ed d\u1ee5: <\/strong>N\u1ebfu \u00f4 A1 ch\u1ee9a s\u1ed1 123, c\u00f4ng th\u1ee9c =TEXT(A1, “00000”) s\u1ebd tr\u1ea3 v\u1ec1 00123.<\/p>\n

    \"H\u01b0\u1edbng<\/em><\/p>\n

    C\u00e1ch th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u trong Excel b\u1eb1ng h\u00e0m TEXT<\/em><\/p>\n

    \n

    S\u1eed d\u1ee5ng h\u00e0m RIGHT<\/h3>\n<\/div>\n

    C\u00fa ph\u00e1p:<\/strong> =RIGHT(“000000″&A1, 6). Trong \u0111\u00f3:<\/p>\n

      \n
    • “000000”&A1: Gh\u00e9p chu\u1ed7i s\u1ed1 0 v\u1edbi gi\u00e1 tr\u1ecb trong \u00f4 b\u1ea1n mu\u1ed1n th\u00eam s\u1ed1 0.<\/li>\n
    • 6: S\u1ed1 ch\u1eef s\u1ed1 t\u1ed1i \u0111a b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb.<\/li>\n<\/ul>\n

      \"Th\u00eam<\/em><\/p>\n

      S\u1eed d\u1ee5ng h\u00e0m RIGHT \u0111\u1ec3 th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u<\/em><\/p>\n

      V\u00ed d\u1ee5: <\/strong>N\u1ebfu \u00f4 A1 ch\u1ee9a 45, c\u00f4ng th\u1ee9c =RIGHT(“00000″&A1, 5) s\u1ebd tr\u1ea3 v\u1ec1 00045.<\/p>\n

      \n

      3. C\u00e1ch th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u trong Excel b\u1eb1ng Format Cell<\/h2>\n<\/div>\n

      S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Format Cell \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 m\u00e0 kh\u00f4ng thay \u0111\u1ed5i gi\u00e1 tr\u1ecb g\u1ed1c. C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

      B\u01b0\u1edbc 1: <\/strong>Ch\u1ecdn c\u00e1c \u00f4 c\u1ea7n th\u00eam s\u1ed1 0. Nh\u1ea5n chu\u1ed9t ph\u1ea3i, ch\u1ecdn Format Cells.<\/p>\n

      B\u01b0\u1edbc 2:<\/strong> Trong m\u1ee5c Category, ch\u1ecdn Custom.<\/p>\n

      B\u01b0\u1edbc 3: <\/strong>T\u1ea1i \u00f4 Type, nh\u1eadp s\u1ed1 l\u01b0\u1ee3ng 0 m\u00e0 b\u1ea1n mu\u1ed1n th\u00eam, v\u00ed d\u1ee5 00000 (cho s\u1ed1 c\u00f3 5 ch\u1eef s\u1ed1). K\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb nh\u01b0 sau:<\/p>\n

      \"H\u01b0\u1edbng<\/em><\/p>\n

      C\u00e1ch th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u trong Excel b\u1eb1ng Format Cell<\/em><\/p>\n

      \n

      4. C\u00e1ch th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u trong Excel b\u1eb1ng \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n<\/h2>\n<\/div>\n

      Chuy\u1ec3n \u00f4 sang \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n l\u00e0 m\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 gi\u1eef s\u1ed1 0 \u1edf \u0111\u1ea7u. C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

      B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn c\u00e1c \u00f4 c\u1ea7n \u0111\u1ecbnh d\u1ea1ng.<\/p>\n

      B\u01b0\u1edbc 2: <\/strong>V\u00e0o tab Home, trong nh\u00f3m Number, ch\u1ecdn Format Dropdown. Sau \u0111\u00f3 ti\u1ebfp t\u1ee5c ch\u1ecdn Text t\u1eeb danh s\u00e1ch \u0111\u1ecbnh d\u1ea1ng.<\/p>\n

      B\u01b0\u1edbc 3: <\/strong>Nh\u1eadp s\u1ed1 v\u1edbi s\u1ed1 0 \u1edf \u0111\u1ea7u, v\u00ed d\u1ee5 00123, v\u00e0 nh\u1ea5n Enter.<\/p>\n

      \"H\u01b0\u1edbng<\/em><\/p>\n

      C\u00e1ch th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u trong Excel b\u1eb1ng \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n<\/em><\/p>\n

      C\u00e1ch n\u00e0y \u0111\u1ea3m b\u1ea3o s\u1ed1 0 kh\u00f4ng b\u1ecb m\u1ea5t nh\u01b0ng d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c l\u01b0u d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n.<\/p>\n

      Xem th\u00eam: <\/strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u00f3a c\u00f4ng th\u1ee9c trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng<\/div>\n

      Hy v\u1ecdng v\u1edbi c\u00e1ch th\u00eam s\u1ed1 0 \u1edf \u0111\u1ea7u trong Excel m\u00e0 Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn v\u1eeba g\u1ee3i \u00fd, b\u1ea1n s\u1ebd d\u1ec5 d\u00e0ng nh\u1eadp d\u1eef li\u1ec7u theo \u0111\u1ecbnh d\u1ea1ng mong mu\u1ed1n m\u00e0 kh\u00f4ng b\u1ecb m\u1ea5t ch\u1eef s\u1ed1 0. T\u00f9y thu\u1ed9c v\u00e0o nhu c\u1ea7u, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1ch ph\u00f9 h\u1ee3p nh\u1ea5t \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c.<\/p>\n

      H\u00e3y n\u00e2ng c\u1ea5p tr\u1ea3i nghi\u1ec7m l\u00e0m vi\u1ec7c c\u1ee7a b\u1ea1n v\u1edbi m\u1ed9t chi\u1ebfc m\u00e1y t\u00ednh b\u1ea3ng ch\u1ea5t l\u01b0\u1ee3ng! Gh\u00e9 ngay Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 ch\u1ecdn mua m\u00e1y t\u00ednh b\u1ea3ng hi\u1ec7n \u0111\u1ea1i, h\u1ed7 tr\u1ee3 c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng v\u00e0 h\u1ecdc t\u1eadp hi\u1ec7u qu\u1ea3. Mua s\u1eafm ngay h\u00f4m nay \u0111\u1ec3 nh\u1eadn \u01b0u \u0111\u00e3i h\u1ea5p d\u1eabn!<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

      B\u1ea1n \u0111\u00e3 bao gi\u1edd g\u1eb7p t\u00ecnh hu\u1ed1ng g\u00f5 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i ho\u1eb7c s\u1ed1 CCCD v\u00e0o Excel, nh\u01b0ng s\u1ed1 0 \u1edf \u0111\u1ea7u b\u1ed7ng nhi\u00ean bi\u1ebfn m\u1ea5t? \u0110\u1eebng lo l\u1eafng! \u0110\u00e2y l\u00e0 v\u1ea5n \u0111\u1ec1 ph\u1ed5 bi\u1ebfn khi l\u00e0m vi\u1ec7c v\u1edbi Excel nh\u01b0ng b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c d\u1ec5 d\u00e0ng. Trong b\u00e0i vi\u1ebft n\u00e0y, Si\u00eau Th\u1ecb […]<\/p>\n","protected":false},"author":1,"featured_media":2366,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-2365","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/10\/18854.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/2365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=2365"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/2365\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/2366"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=2365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=2365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=2365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}