Modify Currency Document in Google Drive For Free

To apply a custom currency format to your spreadsheet: On your computer, open a spreadsheet in Google Sheets. Highlight the data that you want to format. Click Format. Number. Click Custom currency. Search in the menu text box to select a format. ... Click Apply.

Highlight the cell or column with the currency information you want to change, then locate the "More formats" option between font selection and the "Increase decimal places" option in the toolbar. In the drop-down menu, select the option that reads "Custom currency" and select the correct currency from the list.

Tap a cell, then drag the blue markers across nearby cells you want to select. In the "Text" tab, choose an option to format your text. In the "Cell" tab, choose an option to format your cell.

How do I change the currency on Android/iOS? Open the Google Play Store app on your Android device. Tap the profile icon in the top right corner of your screen. Tap Settings > General > Account and device preferences > Country and profiles. Tap the required country. Add a payment method for the new country.

Convert Numbers to Indian Rupees in Google Sheets Now switch to the Google Sheet, type =INR(123) in any cell and it will instantly spell the number in words using the lakhs and crores system.

To format numbers, dates, or currencies in a spreadsheet, follow these steps: On your Android phone or tablet, open a spreadsheet in the Google Sheets app. Tap a cell or range of cells. Tap Format. . Tap Cell. Number format. Tap an option from the list. The format will be applied to your selected cells.

(1) Select a range with numbers (C2:C8), (2) click on the More formats icon (123) in the toolbar, (3) select More Formats and (4) click on More currencies. 2. In the Custom currencies window, (1) select Indian Rupee, (2) choose the appropriate format (?1,000) and (3) click Apply.