{"id":10777,"date":"2025-01-14T23:42:36","date_gmt":"2025-01-14T23:42:36","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/de-dang-lam-cho-excel-nhan-ra-du-lieu-so\/"},"modified":"2025-01-14T23:42:36","modified_gmt":"2025-01-14T23:42:36","slug":"de-dang-lam-cho-excel-nhan-ra-du-lieu-so","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/de-dang-lam-cho-excel-nhan-ra-du-lieu-so\/","title":{"rendered":"D\u1ec5 d\u00e0ng l\u00e0m cho Excel nh\u1eadn ra d\u1eef li\u1ec7u s\u1ed1"},"content":{"rendered":"
\n

Nh\u01b0 \u1edf c\u00e1c b\u00e0i tr\u01b0\u1edbc m\u00ecnh \u0111\u00e3 c\u00f3 c\u01a1 h\u1ed9i gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n nh\u1eefng ti\u1ec7n \u00edch tuy\u1ec7t v\u1eddi c\u1ee7a c\u00f4ng c\u00f4ng c\u1ee5 ph\u1ee5 tr\u1ee3 cho Excel l\u00e0 ASAP Utilities. H\u00f4m nay m\u00ecnh s\u1ebd ti\u1ebfp t\u1ee5c \u0111i kh\u00e1m ph\u00e1 s\u1ef1 tuy\u1ec7t v\u1eddi c\u1ee7a c\u00f4ng c\u1ee5 n\u00e0y, m\u00ecnh xin gi\u1edbi thi\u1ec7u c\u00e1ch \u0111\u1ec3 Excel d\u1ec5 d\u00e0ng nh\u1eadn ra \u0111\u00e2u l\u00e0 d\u1eef li\u1ec7u s\u1ed1.<\/p>\n

\u0110\u00f4i khi Excel x\u1ea3y ra m\u1ed9t s\u1ed1 l\u1ed7i d\u1eabn \u0111\u1ebfn vi\u1ec7c th\u1ea5t b\u1ea1i trong vi\u1ec7c nh\u1eadn d\u1ea1ng d\u1eef li\u1ec7u s\u1ed1 kh\u00f4ng ch\u00ednh x\u00e1c,\u00a0nh\u1eefng k\u1ebft qu\u1ea3 kh\u00f4ng mong mu\u1ed1n n\u00e0y x\u1ea3y ra\u00a0khi b\u1ea1n th\u1ef1c hi\u1ec7n s\u1eafp x\u1ebfp, l\u1ecdc ho\u1eb7c s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c.<\/p>\n

V\u00ed d\u1ee5: khi b\u1ea1n c\u00f3 m\u1ed9t t\u1ec7p \u0111\u01b0\u1ee3c t\u1ea1o ra t\u1eeb trong ch\u01b0\u01a1ng tr\u00ecnh kh\u00e1c, ch\u1eb3ng h\u1ea1n b\u1eb1ng ph\u1ea7n m\u1ec1m\u00a0k\u1ebf to\u00e1n, \u0111\u01b0\u1ee3c t\u1ea3i xu\u1ed1ng t\u1eeb m\u00e1y t\u00ednh c\u00f3 b\u1ed9 nh\u1edb l\u1edbn ho\u1eb7c \u0111\u01b0\u1ee3c sao ch\u00e9p t\u1eeb trang web, sau \u0111\u00f3 Excel c\u00f3 th\u1ec3 kh\u00f4ng nh\u1eadn ra \u0111\u01b0\u1ee3c s\u1ed1 li\u1ec7u.<\/p>\n

M\u1ed9t s\u1ed1 gi\u00e1 tr\u1ecb Excel c\u00f3 th\u1ec3 tr\u00f4ng gi\u1ed1ng nh\u01b0 c\u00e1c con s\u1ed1, nh\u01b0ng Excel ngh\u0129 \u0111\u00f3 l\u00e0 d\u1ea1ng v\u0103n b\u1ea3n. Nh\u1eefng con s\u1ed1 n\u00e0y sau \u0111\u00f3 th\u01b0\u1eddng \u0111\u01b0\u1ee3c c\u0103n l\u1ec1 tr\u00e1i (m\u1eb7c \u0111\u1ecbnh, v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c c\u0103n l\u1ec1 tr\u00e1i v\u00e0 c\u00e1c con s\u1ed1 \u0111\u01b0\u1ee3c c\u0103n l\u1ec1 ph\u1ea3i trong Excel).<\/p>\n

\u0110\u00f4i khi b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i nh\u1eefng tr\u01b0\u1eddng h\u1ee3p:
\n\u2013 C\u00f4ng th\u1ee9c kh\u00f4ng t\u00ednh \u0111\u00fang k\u1ebft qu\u1ea3\u00a0c\u1ee7a b\u1ea1n, ch\u1eb3ng h\u1ea1n nh\u01b0 d\u00f9ng h\u00e0m SUM cho c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn, b\u1edfi v\u00ec s\u1ed1 \u2018text\u2019- n\u00ean d\u1eef li\u1ec7u b\u1ecb b\u1ecf qua.
\n\u2013 Excel kh\u00f4ng cho ph\u00e9p b\u1ea1n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng s\u1ed1 c\u1ee7a c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn.
\n\u2013 Th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp \u00a0g\u00e2y nh\u1ea7m l\u1eabn v\u00e0 kh\u00f4ng ch\u00ednh x\u00e1c.
\n\u2013 D\u1eef li\u1ec7u d\u1ea1ng\u00a0ph\u00e2n s\u1ed1 trong \u00f4 c\u1ee7a b\u1ea1n m\u00e0 Excel kh\u00f4ng nh\u1eadn ra \u0111\u00f3 l\u00e0 d\u1eef li\u1ec7u s\u1ed1v\u00e0 kh\u00f4ng th\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c, ch\u1eb3ng h\u1ea1n nh\u01b0 1\/4.
\n\u2013 Excel \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng ki\u1ec3m tra l\u1ed7i t\u00f9y ch\u1ecdn v\u00e0 s\u1eeda ch\u1eefa kh\u00f4ng c\u00f3 s\u1eb5n ho\u1eb7c kh\u00f4ng s\u1eeda ch\u1eefa \u0111\u01b0\u1ee3c c\u00e1c con s\u1ed1.<\/p>\n

Nh\u01b0ng v\u1edbi\u00a0ASAP Utilities th\u00ec vi\u1ec7c kh\u1eafc ph\u1ee5c n\u00e0y tr\u1edf l\u00ean d\u1ec5 d\u00e0ng h\u01a1n bao gi\u1edd h\u1ebft. V\u00ed d\u1ee5 m\u00ecnh c\u00f3 d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n

\"vidu1\"<\/p>\n

B\u1ea1n \u0111\u1ec3 \u00fd nh\u00e9, nh\u1eefng d\u1eef li\u1ec7u c\u00f3 m\u00e0u \u0111\u1ecf l\u00e0 nh\u1eefng d\u1eef li\u1ec7u s\u1ed1 m\u00e0 Excel kh\u00f4ng th\u1ec3 nh\u1eadn d\u1ea1ng \u0111\u01b0\u1ee3c \u0111\u00f3 l\u00e0 s\u1ed1. V\u00ed d\u1ee5 d\u1eef li\u1ec7u trong ph\u1ea7n \u0111\u01b0\u1ee3c ch\u1ecdn, Excel x\u1ea3y ra l\u1ed7i khi nh\u1eadn d\u1ea1ng ch\u00fang n\u00ean k\u1ebft qu\u1ea3 t\u00ednh v\u1edbi c\u00e1c d\u1eef li\u1ec7u n\u00e0y \u0111\u1ed3ng lo\u1ea1t tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u00f4ng ch\u00ednh x\u00e1c . V\u1eady c\u00e1ch s\u1eeda s\u1ebd nh\u01b0 th\u1ebf n\u00e0o?<\/p>\n

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

C\u00f4ng vi\u1ec7c c\u1ea7n l\u00e0m c\u1ee7a c\u00e1c b\u1ea1n l\u00e0 ti\u1ebfn h\u00e0nh ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u \u0111\u00f3 r\u1ed3i \u0111i v\u00e0o th\u1ebb\u00a0ASAP Utilities tr\u00ean thanh menu c\u1ee7a Excel: Ch\u1ecdn Numbers & Dates => Convert unrecognized numbers (text?) to numbers<\/strong><\/em><\/p>\n

(<\/em>l\u00e0m nh\u01b0 h\u00ecnh minh h\u1ecda\u00a0<\/i>ph\u00eda tr\u00ean nh\u00e9!).<\/i><\/p>\n

K\u1ebft qu\u1ea3 b\u1ea1n nh\u1eadn v\u1ec1 s\u1ebd nh\u01b0 sau:<\/p>\n

\"vidu\"<\/p>\n

B\u1ea1n th\u1ea5y \u0111\u00f3, sau khi \u0111\u01b0\u1ee3c s\u1eeda ch\u1eefa th\u00ec c\u00e1c ph\u00e9p t\u00ednh c\u1ee7a ch\u00fang ta \u0111\u00e3 tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 \u0111\u00fang.<\/p>\n

C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 theo d\u00f5i b\u00e0i vi\u1ebft. H\u1eb9n g\u1eb7p l\u1ea1i c\u00e1c b\u1ea1n \u1edf lo\u1ea1t b\u00e0i ti\u1ebfp theo \u0111\u1ec3 c\u00f9ng m\u00ecnh ti\u1ebfp t\u1ee5c kh\u00e1m ph\u00e1 nh\u1eefng ti\u1ec7n \u00edch kh\u00f4ng ng\u1edd c\u1ee7a c\u00f4ng c\u1ee5 ASAP\u00a0Utilities nh\u00e9!<\/p>\n

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