How to Generate Automatic currency symbol in Excel

If friends type or calculate nominal money in Excel, it's a bit less good if the currency symbol is typed in manually, even better if the currency symbol appears automatically when we type in the nominal money.

Now, to generate currency symbols automatically in Excel, the method is very easy. Friends, first determine or select a cell where a currency symbol will appear automatically. After that friends right click on the mouse and select Format Cells.

Then a new window will appear Format cells, friends change from General to Accounting. After that, in the Symbol section, select the currency symbol you want, for example the Rupiah currency symbol or Rp.

After that click OK to save the settings. To use it, friends just write down the desired amount of money, then press enter on the keyboard, then the currency symbol will automatically appear in front of the amount typed earlier.

If you think the explanation above is not clear, I suggest you also watch the video tutorial that I have previously prepared below. Good luck.