Format Currency  
Use  this tool to apply format of currency to a range of cells.

Change the format of your numbers using the Format Currency tool . Click many times to see other types of number formats.


1 click without decimals
2 clicks with one decimal
3 clicks with 2 decimals
Format settings  

This function is available in excel 2007 and above.