Forum

   
 


 

 

Home

ACERD

E-table

FEAT

KDA

Consultancy

Sustainability

CAD standards and management

PMP

Forum

=> AutoCad

Relax

 


     
 



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:

 Font size:
Close tags



Total topics: 29
Total posts: 46
Total users: 1

 
 

 

 
Contact me: phucibst@yahoo.com
This website was created for free with Own-Free-Website.com. Would you also like to have your own website?
Sign up for free