{"id":10083,"date":"2022-03-16T08:51:18","date_gmt":"2022-03-16T01:51:18","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=10083"},"modified":"2022-03-16T08:51:18","modified_gmt":"2022-03-16T01:51:18","slug":"cac-cach-chen-so-0-phia-truoc","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/cac-cach-chen-so-0-phia-truoc\/","title":{"rendered":"C\u00e1c c\u00e1ch ch\u00e8n s\u1ed1 0 ph\u00eda tr\u01b0\u1edbc"},"content":{"rendered":"

Gh\u00e9p chu\u1ed7i<\/h3>\n

\u0110\u1ea7u ti\u00ean n\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb s\u1ed1 0 \u1edf h\u00e0ng lo\u1ea1t c\u00e1c s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong b\u1ea3ng t\u00ednh Excel c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c =0&v\u1ecb tr\u00ed ad c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda b\u00ean d\u01b0\u1edbi cho c\u00e1c b\u1ea1n \u0111\u01b0\u1ee3c tham kh\u1ea3o chi ti\u1ebft h\u01a1n<\/p>\n

\u1ede \u0111\u00e2y th\u00ec ad c\u00f3 5 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong b\u1ea3ng t\u00ednh Excel v\u00e0 \u0111\u01b0\u01a1ng nhi\u00ean ch\u00fang \u0111\u1ec1u kh\u00f4ng hi\u1ec3n th\u1ecb s\u1ed1 0 \u1edf \u0111\u1eb1ng tr\u01b0\u1edbc \u0111\u1ec3 th\u00eam h\u00e0ng lo\u1ea1t s\u1ed1 n\u00e0y trong b\u1ea3ng t\u00ednh th\u00ec ad \u0111\u00e3 nh\u1ea5n sang \u00f4 b\u00ean c\u1ea1nh c\u1ee7a d\u00f2ng 941346363 (\u0111\u00e2y thu\u1ed9c h\u00e0ng A3 trong Excel) ta s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c\u00a0=0&A3<\/strong>\u00a0v\u00e0 nh\u1ea5n\u00a0Enter<\/strong><\/p>\n

\"\"<\/p>\n

Sau khi \u0111\u00e3 s\u1eed d\u1ee5ng xong c\u00f4ng th\u1ee9c n\u00e0y s\u1ed1 0 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb ngay tr\u01b0\u1edbc s\u1ed1 \u0111i\u1ec7n tho\u1ea1i \u0111\u00f3 v\u00e0 \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c b\u1ea1n ch\u1ec9 c\u1ea7n k\u00e9o c\u00f4ng th\u1ee9c \u0111\u00f3 xu\u1ed1ng h\u00e0ng lo\u1ea1t nh\u1eefng s\u1ed1 b\u00ean d\u01b0\u1edbi l\u00e0 xong<\/p>\n

Nh\u1eadp d\u1ea5u nh\u00e1y \u0111\u01a1n<\/h3>\n

Trong c\u00e1ch th\u1ee9 2 n\u00e0y m\u00e0 ad mu\u1ed1n h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n \u0111\u00f3 ch\u00ednh l\u00e0 s\u1eed d\u1ee5ng d\u1ea5u nh\u00e1y \u0111\u01a1n \u0111\u1eb1ng tr\u01b0\u1edbc c\u00e1c s\u1ed1 b\u1ecb m\u1ea5t s\u1ed1 0. Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y ch\u1ec9 n\u00ean \u00e1p d\u1ee5ng \u0111\u1ed1i v\u1edbi b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n c\u00f3 \u00edt d\u00e3y s\u1ed1 nh\u00e9. V\u00ed d\u1ee5 \u1edf \u0111\u00e2y m\u00ecnh mu\u1ed1n hi\u1ec3n th\u1ecb s\u1ed1 0 trong d\u00e3y s\u1ed1\u00a0941346363 n\u00ean m\u00ecnh ch\u1ec9 c\u1ea7n nh\u1eadp \u20180941346363 l\u00e0 xong<\/p>\n

\"\"<\/p>\n

D\u00f9ng h\u00e0m Text<\/h3>\n

Trong Excel c\u00f3 h\u00e0m text gi\u00fap cho b\u1ea3ng t\u00ednh hi\u1ec3u r\u1eb1ng vi\u1ec7c b\u1ea1n nh\u1eadp s\u1ed1 tr\u00ean Excel \u0111\u00f3 l\u00e0 thu\u1ed9c d\u1ea1ng ch\u1eef ch\u1ee9 kh\u00f4ng ph\u1ea3i l\u00e0 ph\u00e9p t\u00ednh th\u00ec c\u00e1c d\u00e3y s\u1ed1 b\u1ea1n nh\u1eadp c\u00f3 0 \u1edf \u0111\u1eb1ng tr\u01b0\u1eddng s\u1ebd kh\u00f4ng b\u1ecb m\u1ea5t. \u0110\u1ec3 s\u1eed d\u1ee5ng c\u00e1c b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c =text( v\u1ecb tr\u00ed,\u201d\\0?\u201d) nh\u01b0 \u1edf \u0111\u00e2y m\u00ecnh nh\u1eadp s\u1ebd c\u00f3 d\u1ea1ng\u00a0=text( A3,\u201d\\0?\u201d)<\/p>\n

\"\"<\/p>\n

\u0110\u1ecbnh d\u1ea1ng s\u1ed1<\/h3>\n

N\u1ebfu nh\u01b0 trong file Excel c\u1ee7a b\u1ea1n ho\u00e0n to\u00e0n l\u00e0 c\u00e1c d\u00e3y s\u1ed1 v\u00e0 mu\u1ed1n th\u00eam s\u1ed1 0 h\u00e0ng lo\u1ea1t th\u00ec vi\u1ec7c s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ki\u1ec3u s\u1ed1 \u1edf ph\u00eda d\u01b0\u1edbi \u0111\u00e2y s\u1ebd kh\u00e1 ph\u00f9 h\u1ee3p. V\u1edbi ph\u01b0\u01a1ng ph\u00e1p n\u00e0y th\u00ec ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 th\u00eam 3 s\u1ed1 0 hay nhi\u1ec1u h\u01a1n n\u1eefa trong Excel \u0111\u1ec1u c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c nh\u00e9. \u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c b\u1ea1n l\u00e0m nh\u01b0 sau<\/p>\n

B\u01b0\u1edbc 1 : K\u00e9o \u0111\u1ec3 ch\u1ecdn nh\u1eefng \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb s\u1ed1 0 h\u00e0ng lo\u1ea1t trong Excel v\u00e0 ti\u1ebfn h\u00e0nh nh\u1ea5n\u00a0Ctrl + 1<\/strong>\u00a0\u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i\u00a0Format Cells<\/strong><\/p>\n

B\u01b0\u1edbc 2 : Trong tab Number m\u1ee5c\u00a0 Category c\u00e1c b\u1ea1n nh\u1ea5n ch\u1ecdn v\u00e0o\u00a0Custom<\/p>\n

B\u01b0\u1edbc 3 : T\u1ea1i\u00a0Type c\u00e1c b\u1ea1n nh\u1eadp nh\u1eefng s\u1ed1 0 m\u00e0 m\u00ecnh mu\u1ed1n hi\u1ec3n th\u1ecb \u1edf \u0111\u1eb1ng tr\u01b0\u1edbc d\u00e3y s\u1ed1 \u0111\u00f3 trong b\u1ea3ng t\u00ednh Excel. ( n\u1ebfu b\u1ea1n mu\u1ed1n th\u00eam 3 s\u1ed1 0 c\u00e1c b\u1ea1n nh\u1eadp 000 \u1edf\u00a0Type n\u00e0y) v\u00e0 nh\u1ea5p OK \u0111\u1ec3 l\u01b0u thay \u0111\u1ed5i<\/p>\n

\"\"<\/p>\n

\u1ede \u0111\u00e2y c\u00e1c b\u1ea1n nh\u00ecn c\u00f3 th\u1ec3 th\u1eafc m\u1eafc v\u1ec1 0 v\u00e0 # th\u00ec \u0111\u00e2y l\u00e0 2 m\u00e3 \u0111\u1ecbnh d\u1ea1ng c\u00f3 ngh\u0129a<\/p>\n

    \n
  • 0 \u2013 l\u00e0 ch\u1ec9 hi\u1ec3n th\u1ecb s\u1ed1 0 \u1edf \u0111\u1eb1ng tr\u01b0\u1edbc d\u00e3y s\u1ed1 trong Excel<\/li>\n
  • # \u2013 l\u00e0 ch\u1ec9 kh\u00f4ng hi\u1ec3n th\u1ecb s\u1ed1 0 th\u00eam v\u00e0o<\/li>\n<\/ul>\n

    Nh\u01b0 v\u1eady th\u00ec \u1edf b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y m\u00ecnh \u0111\u00e3 chia s\u1ebb \u0111\u1ebfn cho c\u00e1c b\u1ea1n c\u00e1ch\u00a0th\u00eam s\u1ed1 0 h\u00e0ng lo\u1ea1t trong excel r\u1ed3i \u0111\u00f3. Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n","protected":false},"excerpt":{"rendered":"

    Gh\u00e9p chu\u1ed7i \u0110\u1ea7u ti\u00ean n\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb s\u1ed1 0 \u1edf h\u00e0ng lo\u1ea1t c\u00e1c s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong b\u1ea3ng t\u00ednh Excel c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c =0&v\u1ecb tr\u00ed ad c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda b\u00ean d\u01b0\u1edbi cho c\u00e1c b\u1ea1n \u0111\u01b0\u1ee3c tham kh\u1ea3o chi ti\u1ebft h\u01a1n \u1ede \u0111\u00e2y th\u00ec ad c\u00f3 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[506],"tags":[],"class_list":["post-10083","post","type-post","status-publish","format-standard","hentry","category-thu-thuat"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/10083","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=10083"}],"version-history":[{"count":1,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/10083\/revisions"}],"predecessor-version":[{"id":10084,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/10083\/revisions\/10084"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=10083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=10083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=10083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}