\n
![\"\"](\"https:\/\/hosoxaydung.com\/upload\/tai-ngay.gif\")
<\/a>\nM\u1eadt kh\u1ea9u :<\/strong> Cu\u1ed1i b\u00e0i vi\u1ebft<\/strong><\/span><\/span><\/p>\n
Step 2: Copy 2 File \u0111\u00e3 gi\u1ea3i n\u00e9n v\u00e0 \u0111\u01b0\u1eddng d\u1eabn\u00a0C:\\Documents and Settings\\(UserName)\\Application Data\\Microsoft\\AddIns<\/p>\n
Step 3:\u00a0V\u00e0o Tools\\ Add-Ins \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Add-Ins sau \u0111\u00f3 click v\u00e0o\u00a0Browse, ch\u1ecdn t\u00ean add-in ” Doiso” v\u00e0 Doisorachu trong danh s\u00e1ch Add-Ins available, r\u1ed3i b\u1ea5m OK.<\/p>\n
Step4: S\u1eed d\u1ee5ng b\u00e2y gi\u1edd 2 h\u00e0m bc, v\u00e0 vnd \u0111\u01b0\u1ee3c\u00a0 d\u00f9ng nh\u01b0 h\u00e0m excel d\u00f9ng b\u1eb1ng c\u00e1ch\u00a0(=bc(\u00f4 c\u1ea7n \u0111\u1ed3i ra ch\u1eef) ho\u1eb7c =vnd(\u00f4 c\u1ea7n \u0111\u1ed3i ra ch\u1eef))<\/p>\n
<\/p>\n
Di chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn v\u1ecb tr\u00ed c\u1ea7n chuy\u1ec3n v\u00e0 g\u00f5 c\u00fa ph\u00e1p: =VND(\u00f4 mu\u1ed1n chuy\u1ec3n s\u1ed1 th\u00e0nh ch\u1eef) => Enter.<\/p>\n
L\u01b0u \u00fd:<\/strong><\/p>\n – V\u1edbi font Vntimes, s\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh nh\u01b0 sau: =VND(s\u1ed1 \u00f4 mu\u1ed1n chuy\u1ec3n,1)<\/span><\/p>\n – V\u1edbi font VNI, s\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh nh\u01b0 sau: =bc(s\u1ed1 \u00f4 mu\u1ed1n chuy\u1ec3n,2)<\/p>\n – Tr\u01b0\u1eddng h\u1ee3p c\u00f3 s\u1ed1 l\u1ebb, s\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh nh\u01b0 sau =VND(\u00f4 mu\u1ed1n chuy\u1ec3n,\u201d\u0111\u1ed3ng\u201d,\u201d\u1ea3o\u201d,3)<\/p>\n B\u01b0\u1edbc 1:\u00a0C\u00e1c b\u1ea1n m\u1edf m\u1ee5c Add-in b\u1eb1ng c\u00e1ch sau:<\/p>\n B\u01b0\u1edbc 2: \u1ede ph\u00eda d\u01b0\u1edbi c\u00e1c b\u1ea1n ch\u1ecdn Add-ins trong m\u1ee5c Manage v\u00e0 k\u00edch n\u00fat Go\u2026<\/p>\n B\u01b0\u1edbc 3: Sau \u0111\u00f3 c\u00e1c b\u1ea1n nh\u1ea5n Browse\u2026 v\u00e0 ch\u1ecdn \u0111\u1ebfn file v\u1eeba t\u1ea3i \u1edf tr\u00ean<\/p>\n B\u01b0\u1edbc 4: \u0110\u00e1nh d\u1ea5u v\u00e0o NTD\u2019s Tools v\u00e0 nh\u1ea5n OK<\/p>\n Sau khi th\u00eam th\u00e0nh c\u00f4ng trong Excel s\u1ebd xu\u1ea5t hi\u1ec7n tab Add-in trong \u0111\u00f3 c\u00f3 ch\u1ee9a c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a goldsapce.com.vn<\/p>\n \u0110\u1ec3 s\u1eed d\u1ee5ng\u00a0(H\u00e0m\u00a0vnd v\u00e0 bc) c\u00e1c b\u1ea1n th\u1ef1c hi\u1ec7n thao t\u00e1c gi\u1ed1ng v\u1edbi Excel 2003. \u0110\u1ed1i v\u1edbi Excel 2010, 2013 c\u00e1c b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c t\u01b0\u01a1ng t\u1ef1 Excel 2007 \u0110\u00e3 ho\u00e0n th\u00e0nh c\u00e1ch chuy\u1ec3n \u0111\u1ed5i s\u1ed1 th\u00e0nh ch\u1eef trong b\u1ea3ng t\u00ednh Excel m\u00e0 kh\u00f4ng m\u1ea5y kh\u00f3 kh\u0103n, v\u1edbi c\u00e1ch n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ed5i c\u00e1c s\u1ed1 li\u1ec7u th\u00e0nh ch\u1eef v\u1edbi c\u00e1c m\u1ec7nh gi\u00e1 vnd, USD, … nh\u1eb1m ph\u1ee5c v\u1ee5 vi\u1ec7c qu\u1ea3n l\u00fd c\u00e1c s\u1ed1 li\u1ec7u, h\u00f3a \u0111\u01a1n, … li\u00ean quan \u0111\u1ebfn ti\u1ec1n t\u1ec7. S\u1eed d\u1ee5ng ti\u1ec7n \u00edch vnd&bc c\u1ee7a Hosoxaydung.com gi\u00fap b\u1ea1n gi\u1ea3m thi\u1ec3u t\u1ed1i \u0111a th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c so v\u1edbi c\u00e1ch th\u1ee7 c\u00f4ng.<\/p>\n Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n Tag: ham doi so ra chu, h\u00e0m \u0111\u1ed5i s\u1ed1 ra ch\u1eef, h\u00e0m \u0111\u1ecdc s\u1ed1 ra ch\u1eef, ham doc so thanh chu<\/strong><\/p>\n C\u00c1C B\u1ea0N COMENT B\u00caN D\u01af\u1edaI M\u00ccNH S\u1ebc TR\u1ee2 GI\u00daP TR\u1ef0C TUY\u1ebeN !<\/strong><\/span><\/p>\n C\u00e2u h\u1ecfi : <\/strong><\/em>thi c\u00f4ng nh\u00e0 x\u01b0\u1edfng<\/strong><\/span><\/p>\r\n M\u1eadt kh\u1ea9u:<\/strong> 201XXXX (7 k\u00fd t\u1ef1 s\u1ed1)<\/strong>\u00a0. Xem c\u00e1ch t\u1ea3i ph\u00eda d\u01b0\u1edbi.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":" G\u1eedi c\u00e1c b\u1ea1n 2 File h\u00e0m \u0111\u1ed5i s\u1ed1 ra ch\u1eef.\u00a01. H\u00e0m bc – \u0110\u1ed5i s\u1ed1 ra ch\u1eef d\u00f9ng cho Font .vn (Ti\u00eau chu\u1ea9n Vi\u1ec7t Nam TCVN3) 2. H\u00e0m vnd – \u0110\u1ed5i s\u1ed1 ra ch\u1eef d\u00f9ng cho Font Unicode H\u01af\u1edaNG D\u1eaaN S\u1eec D\u1ee4NG Step1: T\u1ea3i File Doi so ra chu.rar v\u1ec1 m\u00e1y v\u00e0 gi\u1ea3i n\u00e9n Download…<\/p>\n","protected":false},"author":1,"featured_media":13301,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[],"class_list":["post-268","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ban-ve-nha-xuong"],"_links":{"self":[{"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=\/wp\/v2\/posts\/268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=268"}],"version-history":[{"count":15,"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=\/wp\/v2\/posts\/268\/revisions"}],"predecessor-version":[{"id":10231,"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=\/wp\/v2\/posts\/268\/revisions\/10231"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=\/wp\/v2\/media\/13301"}],"wp:attachment":[{"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tailieuxaydung.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}