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.