Tuesday, May 1, 2012

Excel VB commands to Convert Numbers into Currency

In the below example we are converting a Number to Currency and we are using '$' symbol for display.


We can achieve this using alternate commands like the ones in the below example. However, the above command is a short-hand. Quite handy, ain't it?


Output after converting to INR
We can also change the currency. Suppose we were to display INR (Indian Rupees)




To learn about formatting numbers in Office Excel (the ones like #.##, #,###.00 etc. that you see in the above examples), I would recommend you to refer Excel Help and search for the topic "Create or delete a custom number format"

No comments:

Post a Comment