which of the following format should one use if one wants to put currency data into an excel sheet?

Format numbers in a spreadsheetYou can format your data in several different ways in Google Sheetsso that your spreadsheet and its contents are displayed how you want them. Format

which of the following format should one use if one wants to put currency data into an excel sheet?

Format numbers in a spreadsheet

You can format your data in several different ways in Google Sheetsso that your spreadsheet and its contents are displayed how you want them.

Format numbers, dates, and currencies

To format numbers, dates, or currencies in a spreadsheet, follow these steps:

  1. On your Android phone or tablet, open a spreadsheet in the Google Sheets app.
  2. Tap a cell or range of cells.
  3. Tap Format
Format

.

  1. Tap Cell
and then

Number format.

  1. Tap an option from the list. The format will be applied to your selected cells.

The date, time, and currency options are based on the spreadsheets locale. To see more options, tap More date/timeor More currencies.

See the number format applied to a cell

  1. On your Android phone or tablet, open a spreadsheet in the Google Sheets app.
  2. Tap on a cell or range of cells.
  3. Tap Format
Format

.

  1. Tap Cell.
  2. The number format type is listed next to "Number format."                 Android ComputeriPhone & iPad   More

Video liên quan