{"id":7190,"date":"2024-12-21T17:05:35","date_gmt":"2024-12-21T17:05:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/hai-cach-tot-nhat-de-chuyen-doi-dang-so-sang-chu-trong-excel\/"},"modified":"2024-12-21T17:05:35","modified_gmt":"2024-12-21T17:05:35","slug":"hai-cach-tot-nhat-de-chuyen-doi-dang-so-sang-chu-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/hai-cach-tot-nhat-de-chuyen-doi-dang-so-sang-chu-trong-excel\/","title":{"rendered":"Hai c\u00e1ch t\u1ed1t nh\u1ea5t \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i d\u1ea1ng s\u1ed1 sang ch\u1eef trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i n\u00e0y, <strong><a href=\"https:\/\/hocexcel.online\/\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a> <\/strong>s\u1ebd gi\u1edbi thi\u1ec7u cho c\u00e1c b\u1ea1n hai c\u00e1ch \u0111\u1ec3 <span class=\"keyword _ngcontent-bzk-106\" aria-hidden=\"false\"><strong>chuy\u1ec3n t\u1eeb s\u1ed1 sang ch\u1eef trong excel<\/strong> hay <\/span>chuy\u1ec3n t\u1eeb d\u1ea1ng s\u1ed1 ti\u1ec1n t\u1ec7 sang c\u00e1c t\u1eeb ti\u1ebfng Anh trong Excel 2010, 2013 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n kh\u00e1c ngay sau \u0111\u00e2y.<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6766f55e81b0f\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/hai-cach-tot-nhat-de-chuyen-doi-dang-sang-chu-trong-excel.html#SpellNumber_VBA_macro_de_chuyen_tu_so_sang_chu_trong_Excel\" title=\"SpellNumber VBA macro \u0111\u1ec3 chuy\u1ec3n t\u1eeb s\u1ed1 sang ch\u1eef trong Excel\">SpellNumber VBA macro \u0111\u1ec3 chuy\u1ec3n t\u1eeb s\u1ed1 sang ch\u1eef trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/hai-cach-tot-nhat-de-chuyen-doi-dang-sang-chu-trong-excel.html#Su_dung_macro_SpellNumber_trong_bang_tinh_cua_ban\" title=\"S\u1eed d\u1ee5ng macro SpellNumber trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n\">S\u1eed d\u1ee5ng macro SpellNumber trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/hai-cach-tot-nhat-de-chuyen-doi-dang-sang-chu-trong-excel.html#Sao_chep_nhanh_chuc_nang_SpellNumber_sang_cac_o_khac\" title=\"Sao ch\u00e9p nhanh ch\u1ee9c n\u0103ng SpellNumber sang c\u00e1c \u00f4 kh\u00e1c.\">Sao ch\u00e9p nhanh ch\u1ee9c n\u0103ng SpellNumber sang c\u00e1c \u00f4 kh\u00e1c.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/hai-cach-tot-nhat-de-chuyen-doi-dang-sang-chu-trong-excel.html#Nhuoc_diem_cua_viec_su_dung_macro_de_danh_van_so_trong_Excel\" title=\"Nh\u01b0\u1ee3c \u0111i\u1ec3m c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng macro \u0111\u1ec3 \u0111\u00e1nh v\u1ea7n s\u1ed1 trong Excel\">Nh\u01b0\u1ee3c \u0111i\u1ec3m c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng macro \u0111\u1ec3 \u0111\u00e1nh v\u1ea7n s\u1ed1 trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"SpellNumber_VBA_macro_de_chuyen_tu_so_sang_chu_trong_Excel\"><\/span><strong>SpellNumber <a href=\"http:\/\/blog.ezworkapp.com\/bat-dau-voi-excel-macros-va-lap-trinh-vba.html\" target=\"_blank\" rel=\"noopener noreferrer\">VBA macro<\/a> \u0111\u1ec3 chuy\u1ec3n t\u1eeb s\u1ed1 sang ch\u1eef trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 t\u00f4i \u0111\u00e3 \u0111\u1ec1 c\u1eadp, Microsoft kh\u00f4ng mu\u1ed1n th\u00eam m\u1ed9t c\u00f4ng c\u1ee5 cho nhi\u1ec7m v\u1ee5 n\u00e0y.\u00a0Tuy nhi\u00ean, khi h\u1ecd th\u1ea5y c\u00f3 nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng c\u1ea7n n\u00f3, h\u1ecd \u0111\u00e3 t\u1ea1o v\u00e0 xu\u1ea5t b\u1ea3n <strong>macro VBA<\/strong> \u0111\u1eb7c bi\u1ec7t tr\u00ean trang web c\u1ee7a h\u1ecd.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y c\u00e1c macro \u0111\u01b0\u1ee3c xem l\u00e0 \u201cc\u00f4ng th\u1ee9c spellnumber\u201d.\u00a0Tuy nhi\u00ean, n\u00f3 kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c, m\u00e0 l\u00e0 m\u1ed9t h\u00e0m macro, ho\u1eb7c ch\u00ednh x\u00e1c h\u01a1n l\u00e0 <em>h\u00e0m \u0111\u01b0\u1ee3c ng\u01b0\u1eddi d\u00f9ng \u0111\u1ecbnh ngh\u0129a<\/em>\u00a0(UDF).<\/p>\n<p style=\"text-align: justify\">T\u00f9y ch\u1ecdn \u0111\u00e1nh v\u1ea7n s\u1ed1 c\u00f3 th\u1ec3 vi\u1ebft \u0111\u00f4 la v\u00e0 cent.\u00a0N\u1ebfu b\u1ea1n c\u1ea7n m\u1ed9t lo\u1ea1i ti\u1ec1n t\u1ec7 kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i \u201d\u00a0<em>\u0111\u00f4 la<\/em>\u00a0\u201d v\u00e0 \u201d\u00a0<em>cent<\/em>\u00a0\u201d b\u1eb1ng \u0111\u01a1n v\u1ecb b\u1ea1n c\u1ea7n.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t ng\u01b0\u1eddi hi\u1ec3u bi\u1ebft VBA, d\u01b0\u1edbi \u0111\u00e2y b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y m\u1ed9t b\u1ea3n sao c\u1ee7a m\u00e3.<\/p>\n<ol style=\"text-align: justify\">\n<li>M\u1edf b\u1ea3ng t\u00ednh m\u00e0 b\u1ea1n c\u1ea7n \u0111\u00e1nh v\u1ea7n c\u00e1c con s\u1ed1.<\/li>\n<li>Nh\u1ea5n\u00a0<strong>Alt + F11 <\/strong>\u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 tr\u00ecnh so\u1ea1n th\u1ea3o Visual Basic.<\/li>\n<li>N\u1ebfu b\u1ea1n \u0111ang m\u1edf nhi\u1ec1u t\u1ec7p tin, h\u00e3y ch\u1ecdn b\u1ea3ng t\u00ednh c\u1ea7n thi\u1ebft b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng danh s\u00e1ch c\u00e1c t\u1ec7p \u1edf b\u00ean tr\u00e1i c\u1ee7a tr\u00ecnh so\u1ea1n th\u1ea3o (t\u1ec7p s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u m\u00e0u xanh).<\/li>\n<li>Trong tr\u00ecnh \u0111\u01a1n ch\u1ec9nh s\u1eeda h\u00e3y v\u00e0o\u00a0<em>Insert-&gt;\u00a0Module\u00a0.<\/em><\/li>\n<\/ol>\n<figure style=\"width: 471px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Hai c\u00e1ch t\u1ed1t nh\u1ea5t \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i d\u1ea1ng s\u1ed1 sang ch\u1eef trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba-editor-insert-module.png\" alt=\"Excel Visual Basic editor - insert module\" width=\"471\" height=\"208\"><figcaption class=\"wp-caption-text\">Hai c\u00e1ch t\u1ed1t nh\u1ea5t \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i d\u1ea1ng s\u1ed1 sangf ch\u1eef trong Excel<\/figcaption><\/figure>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>B\u1ea1n s\u1ebd th\u1ea5y c\u1eeda s\u1ed5 c\u00f3 t\u00ean YourBook \u2013 Module1.\u00a0Ch\u1ecdn t\u1ea5t c\u1ea3 m\u00e3 trong khung b\u00ean d\u01b0\u1edbi v\u00e0 d\u00e1n n\u00f3 v\u00e0o c\u1eeda s\u1ed5 n\u00e0y.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5963\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-110.png\" width=\"600\" height=\"403\" title=\"excel-dialog-box-launcher-1-110\"><\/p>\n<pre>Option Explicit\r\n\r\n'Main Function\r\nFunction SpellNumber(ByVal MyNumber)\r\n\tDim Dollars, Cents, Temp\r\n\tDim DecimalPlace, Count\r\n\t\r\n\tReDim Place(9) As String\r\n\t\r\n\tPlace(2) = \" Thousand \"\r\n\tPlace(3) = \" Million \"\r\n\tPlace(4) = \" Billion \"\r\n\tPlace(5) = \" Trillion \"\r\n\t\r\n\tMyNumber = Trim(Str(MyNumber))\r\n\tDecimalPlace = InStr(MyNumber, \".\")\r\n\t\r\n\tIf DecimalPlace &gt; 0 Then\r\n\t\tCents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) &amp; \"00\", 2))\r\n\t\tMyNumber = Trim(Left(MyNumber, DecimalPlace - 1))\r\n\tEnd If\r\n\t\tCount = 1\r\n\t\tDo While MyNumber &lt;&gt; \"\"\r\n\t\t\tTemp = GetHundreds(Right(MyNumber, 3))\r\n\t\t\tIf Temp &lt;&gt; \"\" Then Dollars = Temp &amp; Place(Count) &amp; Dollars\r\n\t\t\tIf Len(MyNumber) &gt; 3 Then\r\n\t\t\t\tMyNumber = Left(MyNumber, Len(MyNumber) - 3)\r\n\t\t\tElse\r\n\t\t\t\tMyNumber = \"\"\r\n\t\t\tEnd If\r\n\t\t\tCount = Count + 1\r\n\t\tLoop\r\n\t\tSelect Case Dollars\r\n\t\t\tCase \"\"\r\n\t\t\tDollars = \"No Dollars\"\r\n\t\t\tCase \"One\"\r\n\t\t\tDollars = \"One Dollar\"\r\n\t\t\tCase Else\r\n\t\t\tDollars = Dollars &amp; \" Dollars\"\r\n\t\tEnd Select\r\n\t\tSelect Case Cents\r\n\t\t\tCase \"\"\r\n\t\t\tCents = \" and No Cents\"\r\n\t\t\tCase \"One\"\r\n\t\t\tCents = \" and One Cent\"\r\n\t\t\tCase Else\r\n\t\t\tCents = \" and \" &amp; Cents &amp; \" Cents\"\r\n\t\tEnd Select\r\n\t\t\r\n\tSpellNumber = Dollars &amp; Cents\r\nEnd Function\r\n\r\nFunction GetHundreds(ByVal MyNumber)\r\n\tDim Result As String\r\n\t\r\n\tIf Val(MyNumber) = 0 Then Exit Function\r\n\t\r\n\tMyNumber = Right(\"000\" &amp; MyNumber, 3)\r\n\t\r\n\t' Convert the hundreds place.\r\n\tIf Mid(MyNumber, 1, 1) &lt;&gt; \"0\" Then\r\n\t\tResult = GetDigit(Mid(MyNumber, 1, 1)) &amp; \" Hundred \"\r\n\tEnd If\r\n\t\r\n\t' Convert the tens and ones place.\r\n\tIf Mid(MyNumber, 2, 1) &lt;&gt; \"0\" Then\r\n\t\tResult = Result &amp; GetTens(Mid(MyNumber, 2))\r\n\tElse\r\n\t\tResult = Result &amp; GetDigit(Mid(MyNumber, 3))\r\n\tEnd If\r\n\t\r\n\tGetHundreds = Result\r\nEnd Function\r\n\r\nFunction GetTens(TensText)\r\n\tDim Result As String\r\n\tResult = \"\" ' Null out the temporary function value.\r\n\r\n\tIf Val(Left(TensText, 1)) = 1 Then\u00a0\u00a0 ' If value between 10-19...\r\n\t\tSelect Case Val(TensText)\r\n\t\t\tCase 10: Result = \"Ten\"\r\n\t\t\tCase 11: Result = \"Eleven\"\r\n\t\t\tCase 12: Result = \"Twelve\"\r\n\t\t\tCase 13: Result = \"Thirteen\"\r\n\t\t\tCase 14: Result = \"Fourteen\"\r\n\t\t\tCase 15: Result = \"Fifteen\"\r\n\t\t\tCase 16: Result = \"Sixteen\"\r\n\t\t\tCase 17: Result = \"Seventeen\"\r\n\t\t\tCase 18: Result = \"Eighteen\"\r\n\t\t\tCase 19: Result = \"Nineteen\"\r\n\t\t\tCase Else\r\n\t\tEnd Select\r\n\tElse ' If value between 20-99...\r\n\t\tSelect Case Val(Left(TensText, 1))\r\n\t\t\tCase 2: Result = \"Twenty \"\r\n\t\t\tCase 3: Result = \"Thirty \"\r\n\t\t\tCase 4: Result = \"Forty \"\r\n\t\t\tCase 5: Result = \"Fifty \"\r\n\t\t\tCase 6: Result = \"Sixty \"\r\n\t\t\tCase 7: Result = \"Seventy \"\r\n\t\t\tCase 8: Result = \"Eighty \"\r\n\t\t\tCase 9: Result = \"Ninety \"\r\n\t\tCase Else\r\n\t\tEnd Select\r\n\tResult = Result &amp; GetDigit _\r\n\t(Right(TensText, 1))\u00a0 ' Retrieve ones place.\r\n\tEnd If\r\n\t\r\n\tGetTens = Result\r\nEnd Function\r\n\r\nFunction GetDigit(Digit)\r\n\tSelect Case Val(Digit)\r\n\t\tCase 1: GetDigit = \"One\"\r\n\t\tCase 2: GetDigit = \"Two\"\r\n\t\tCase 3: GetDigit = \"Three\"\r\n\t\tCase 4: GetDigit = \"Four\"\r\n\t\tCase 5: GetDigit = \"Five\"\r\n\t\tCase 6: GetDigit = \"Six\"\r\n\t\tCase 7: GetDigit = \"Seven\"\r\n\t\tCase 8: GetDigit = \"Eight\"\r\n\t\tCase 9: GetDigit = \"Nine\"\r\n\t\tCase Else: GetDigit = \"\"\r\n\tEnd Select\r\nEnd Function<\/pre>\n<ol style=\"text-align: justify\" start=\"6\">\n<li>Nh\u1ea5n <strong>Ctrl + S<\/strong> \u0111\u1ec3 l\u01b0u b\u1ea3ng t\u00ednh \u0111\u00e3 c\u1eadp nh\u1eadt.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">B\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i l\u01b0u l\u1ea1i b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n. Khi b\u1ea1n c\u1ed1 g\u1eafng l\u01b0u b\u1ea3ng t\u00ednh v\u1edbi m\u1ed9t macro, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o \u201d C\u00e1c t\u00ednh n\u0103ng sau \u0111\u00e2y kh\u00f4ng th\u1ec3 \u0111\u01b0\u1ee3c l\u01b0u trong b\u1ea3ng t\u00ednh macro\u201d<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-287.gif\" title=\"vba101_92019-nho-287\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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\/2024\/12\/ex101_92019-nho-650.gif\" title=\"ex101_92019-nho-650\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure style=\"width: 634px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1c t\u00ednh n\u0103ng sau \u0111\u00e2y kh\u00f4ng th\u1ec3 \u0111\u01b0\u1ee3c l\u01b0u trong b\u1ea3ng t\u00ednh macro\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cannot-save-vbproject.png\" alt=\"The following features cannot be saved in macro-free Workbook : VB project\" width=\"634\" height=\"179\"><figcaption class=\"wp-caption-text\"><em>C\u00e1c t\u00ednh n\u0103ng sau \u0111\u00e2y kh\u00f4ng th\u1ec3 \u0111\u01b0\u1ee3c l\u01b0u trong b\u1ea3ng t\u00ednh macro<\/em><\/figcaption><\/figure>\n<p style=\"text-align: justify\">Nh\u1ea5p v\u00e0o <strong>NO<\/strong>. Khi b\u1ea1n th\u1ea5y m\u1ed9t h\u1ed9p tho\u1ea1i m\u1edbi, ch\u1ecdn t\u00f9y ch\u1ecdn \u201d\u00a0<strong><em>Save as type<\/em>\u00a0\u201d v\u00e0 \u201c<em>Excel macro-enabled workbook<\/em>\u00a0\u201c.<\/strong><\/p>\n<figure id=\"attachment_5964\" aria-describedby=\"caption-attachment-5964\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5964 size-full\" title='\u00a0Save as type\u00a0\" v\u00e0 \"Excel macro-enabled workbook' src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-111.png\" alt='\u00a0Save as type\u00a0\" v\u00e0 \"Excel macro-enabled workbook' width=\"600\" height=\"462\"><figcaption id=\"caption-attachment-5964\" class=\"wp-caption-text\"><em>\u00a0Save as type\u00a0\u201d v\u00e0 \u201cExcel macro-enabled workbook<\/em><\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_macro_SpellNumber_trong_bang_tinh_cua_ban\"><\/span><strong>S\u1eed d\u1ee5ng macro SpellNumber trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m\u00a0<em>SpellNumber<\/em>.\u00a0Nh\u1eadp\u00a0<strong>=SpellNumber(A2) <\/strong>v\u00e0o \u00f4 n\u01a1i b\u1ea1n c\u1ea7n l\u1ea5y s\u1ed1 \u0111\u01b0\u1ee3c vi\u1ebft b\u1eb1ng t\u1eeb.\u00a0\u1ede \u0111\u00e2y A2 l\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 c\u00f3 s\u1ed1 ho\u1eb7c s\u1ed1.<\/p>\n<figure style=\"width: 485px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Spelled out numbers to dollars and cents\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-spellnumber-function.png\" alt=\"Spelled out numbers to dollars and cents\" width=\"485\" height=\"350\"><figcaption class=\"wp-caption-text\">Spelled out numbers to dollars and cents<\/figcaption><\/figure>\n<p style=\"text-align: justify\">\u1ede \u0111\u00e2y b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y k\u1ebft qu\u1ea3:<\/p>\n<figure style=\"width: 485px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Spelled out numbers to dollars and cents\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-spellnumber-function.png\" alt=\"Spelled out numbers to dollars and cents\" width=\"485\" height=\"350\"><figcaption class=\"wp-caption-text\">S\u1eed d\u1ee5ng macro SpellNumber trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n<\/figcaption><\/figure>\n<p style=\"text-align: justify\">\u0110\u01b0\u1ee3c r\u1ed3i !<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Sao_chep_nhanh_chuc_nang_SpellNumber_sang_cac_o_khac\"><\/span><strong>Sao ch\u00e9p nhanh ch\u1ee9c n\u0103ng SpellNumber sang c\u00e1c \u00f4 kh\u00e1c.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n chuy\u1ec3n \u0111\u1ed5i to\u00e0n b\u1ed9 b\u1ea3ng, kh\u00f4ng ch\u1ec9 1 \u00f4, \u0111\u1eb7t con tr\u1ecf chu\u1ed9t \u0111\u1ebfn g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 v\u1edbi c\u00f4ng th\u1ee9c cho \u0111\u1ebfn khi n\u00f3 bi\u1ebfn th\u00e0nh m\u1ed9t ch\u1eef th\u1eadp nh\u1ecf m\u00e0u \u0111en:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-convert-formula.png\" alt=\"Quickly copy the SpellNumber function to other cells\" title=\"copy-convert-formula\"><\/p>\n<p style=\"text-align: justify\">Nh\u1ea5p chu\u1ed9t tr\u00e1i v\u00e0 k\u00e9o n\u00f3 qua c\u1ed9t \u0111\u1ec3 \u0111i\u1ec1n v\u00e0o c\u00f4ng th\u1ee9c.\u00a0Nh\u1ea3 n\u00fat \u0111\u1ec3 xem k\u1ebft qu\u1ea3:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/convert-all-numbers-2words.png\" alt=\"Spelled out numbers to dollars and cents\" title=\"convert-all-numbers-2words\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa th\u00edch.\u00a0<\/strong>H\u00e3y ghi nh\u1edb r\u1eb1ng n\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng SpellNumber v\u1edbi m\u1ed9t li\u00ean k\u1ebft \u0111\u1ebfn m\u1ed9t \u00f4 kh\u00e1c, s\u1ed1 ti\u1ec1n b\u1eb1ng v\u0103n b\u1ea3n s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt m\u1ed7i khi s\u1ed1 trong \u00f4 ngu\u1ed3n \u0111\u01b0\u1ee3c thay \u0111\u1ed5i.<br \/>\nB\u1ea1n c\u0169ng c\u00f3 th\u1ec3 nh\u1eadp s\u1ed1 tr\u1ef1c ti\u1ebfp v\u00e0o h\u00e0m, v\u00ed d\u1ee5,\u00a0<strong>=SpellNumber(29.95) <\/strong>(29,95 \u2013 kh\u00f4ng c\u00f3 d\u1ea5u ngo\u1eb7c k\u00e9p v\u00e0 d\u1ea5u \u0111\u00f4 la).<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Nhuoc_diem_cua_viec_su_dung_macro_de_danh_van_so_trong_Excel\"><\/span><strong>Nh\u01b0\u1ee3c \u0111i\u1ec3m c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng macro \u0111\u1ec3 \u0111\u00e1nh v\u1ea7n s\u1ed1 trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Tr\u01b0\u1edbc h\u1ebft, b\u1ea1n ph\u1ea3i bi\u1ebft VBA s\u1eeda \u0111\u1ed5i m\u00e3 theo nhu c\u1ea7u c\u1ee7a b\u1ea1n.\u00a0B\u1ea1n c\u1ea7n d\u00e1n m\u00e3 cho m\u1ed7i b\u1ea3ng t\u00ednh, n\u01a1i b\u1ea1n mu\u1ed1nh thay \u0111\u1ed5i n\u00f3.\u00a0N\u1ebfu kh\u00f4ng, b\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i t\u1ea1o t\u1ec7p m\u1eabu c\u00f3 macro v\u00e0 \u0111\u1ecbnh c\u1ea5u h\u00ecnh Excel \u0111\u1ec3 t\u1ea3i t\u1ec7p n\u00e0y v\u00e0o m\u1ed7i l\u1ea7n b\u1eaft \u0111\u1ea7u.<\/p>\n<p style=\"text-align: justify\">B\u1ea5t l\u1ee3i ch\u00ednh c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng macro l\u00e0 n\u1ebfu b\u1ea1n g\u1eedi b\u1ea3ng t\u00ednh t\u1edbi ng\u01b0\u1eddi kh\u00e1c, ng\u01b0\u1eddi n\u00e0y s\u1ebd kh\u00f4ng nh\u00ecn th\u1ea5y v\u0103n b\u1ea3n tr\u1eeb khi macro \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p v\u00e0o b\u1ea3ng t\u00ednh.\u00a0V\u00e0 ngay c\u1ea3 khi n\u00f3 \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p, h\u1ecd s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c c\u1ea3nh b\u00e1o r\u1eb1ng c\u00f3 nh\u1eefng macro trong b\u1ea3ng t\u00ednh.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/exce-macro-security-notice.png\" alt=\"Add a macro to your workbook\" title=\"exce-macro-security-notice\"><\/p>\n<h2 style=\"text-align: justify\"><\/h2>\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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-287.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7191,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7190","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7190","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=7190"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7190\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7191"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}