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  
 
 

 
 
Note:
This function is available in excel 2007 and above.