This add-in support changecase procedure for Unicode string in vietnamese and support convert amount of money in number to string
Setup
This add-in is tested only on Microsoft Excel 2002 (Excel XP), for other Excel version, this setup maybe is not correct and this add-in maybe does'nt work!
For Excel XP, folder of add-in is C:\Documents and Settings\<user-name>\Application Data\Microsoft\AddIns, with <user-name> is windows login name of user. Copy file vbaVanXuan.xla to the folder of add-in.
Open Excel, select menu Tools/Add-Ins..., check the checkbox beside VBAVanXuan, then OK.
How to use
Change selected cells to UPPERCASE
Press Ctrl + Shift + U.
First
Select
Press
Result
Ctrl + Shift + U
Change selected cells to LOWERCASE
Press Ctrl + Shift + L.
First
Select
Press
Result
Ctrl + Shift + L
Change selected cells to PROPERCASE
Press Ctrl + Shift + P.
First
Select
Press
Result
Ctrl + Shift + P
Convert amount to string
Use function vxMoney(amount). The amount must be equal or less than 1E+15.
Example 1: =vxMoney(100) has the result is Một trăm đồng
Example 2:
Formula
Result
Auto convert amount to string
Select two cells, one has amount and other is blank, then press Ctrl + Shift + M.
