Diễn đàn Phần mềm Xây dựng Forum - Đọc số thành chữ You are here: Forum => VBA Excel - Lập trình trong Excel => Đọc số thành chữ <-Back  1  Continue-> Bluto (Gast) 12/01/2008 7:07am (UTC) [quote] Hàm Tienchu(): đổi số tiền thành chữ VD: =Tienchu(10) : Mười đồng (Font .Vntime) Nếu cần đọc số tiền USD thì dùng hàm: TienUSD() -------------Cách sử dụng---------------------- 1. Download file "Doc so tien.xla" về máy: http://www.4shared.com/file/73913246/ec86f238/Doc_so_tien.html 2. Excel 2003 hoặc phiên bản cũ hơn: - Vào ToolsAdd-Ins, chọn Browser (chọn file Doc so tien.xla mà bạn vừa download về - Click OK 3. Excel 2007: - Click nút Custumize Quick Access Toolbar, chọn More Commands (Phía trên cùng, bên phải, cạnh nút Undo, Redo) - Chọn Add-Ins. Nhìn phía dưới trong ô Manage, chọn Excel Add-Ins, click Go. - Chọn Browser (chọn file Doc so tien.xla mà bạn vừa download về - Click OK -----------Sử dụng--------------------- Bây giờ hàm Tienchu() và hàm TienUSD() đã được tự động nối vào trong Excel như một hàm sãn có của Excel. Trong ô A1 nhập: 1000 Trong ô B1 nhập: =Tienchu(A1) Trong ô C1 nhập: =TienUSD(A1) Mọi thắc mắc vui lòng liên hệ: phucibst@yahoo.com NdBTEhdrztrQ (Gast) 10/25/2014 11:08pm (UTC) [quote] hey here and thank you for your info e2€“ Ie2€™ve certainly pikecd up something new from right here. I did but expertise several technical issues using this site, as I experienced to reload the site many times before to I could get it to load correctly. I had been wondering if your web hosting is OK? Not that I'm complaining, but slow loading instances times will sometimes affect your placement in google and can hurt your high-quality score if publicity and marketing with Adwords. Well Ie2€™m adding this RSS to my e-mail and can look out for much more of your respective fascinating content. Ensure that you update this again very soon.. hjj03CDfiDgc (Gast) 10/29/2014 2:25pm (UTC) [quote] My spouse and i fhnesiid up being so cottenned that Raymond managed to conclude his basic research owing to the entire thoughts he made out of the weblog. It's not at all simplistic to simply continually be giving out information that many some others may have been trying to sell. Therefore we remember we have the website owner to be grateful to for that. The main explanations you have made, the straightforward web site menu, the relationships you can make it simpler to instill it is mostly surprising, and it's really leading our son and us imagine that this content is thrilling, which is tremendously pressing. Thank you for the whole business! Answer: Nickname:  Text color: Standard Dark red Red Orange Brown Yellow Green Olive Cyan Blue Dark blue Indigo Purple White Black  Font size: Very small Small Normal Big Very big Close tags Total topics: 29 Total posts: 46 Total users: 1