Question

How can you change your number into date type ? Can you suggest a way to add currency symbol in front of your numbers? ​

Answer 1

On the Home tab, click the Dialog Box Launcher next to Number. Tip: You can also press Ctrl+1 to open the Format Cells dialog box. In the Format Cells dialog box, in the Category list, click Currency or Accounting. In the Symbol box, click the currency symbol that you want.