Formatting cells to display a date style

Select the cells you wish to format and on the home tab of the ribbon select the drop-down box from the number section.

On this menu, you can select the format of the data, such as a date, time or currency. When you format data to a currency you can select which currency by selecting the $ button.