How to change currency format in OpenOffice Spreadsheet?
To change currency symbol for a cell follow the below steps,
Step 1: Enter a number in the cell.
Step 2: Open the format cells dialog box. Press Ctrl+1 (Shortcut). For other methods of opening the format cells,Click here
Step 3: In the format cells dialog box, under the Numbers tab→Category→Click Currency and in the Format option choose the currency type you want.
Step 4: You can also choose the Decimal places and Leading zeroes option.