Sometimes we need to switch between different currencies in sheet editing.

But setting the currency format is a big problem.

Here are three quick steps.

Hope they can be of some use to you.

Step 1: Open a sheet and select the cell to be operated.

Tap the Format Cells tab on the tool bar to open the Format Cells catalog


Step 2:In the Format Cells Catalog, press the first tab Number.

Select Currency by taping the little triangle on the right of General.



Step 3: To select Currency Symbol.

tap its right side and choose in the drop-down list. Set other details almost in the same manner.


Source: Internet