When using autofill which value will be in the next cell if the first two cells contain sun and mon

There are several buttons to control number format directly. These will apply that format to the select cell or range.Both Excel and Google Sheets include buttons for:CurrencyPerce

When using autofill which value will be in the next cell if the first two cells contain sun and mon
In Excel: Home  Number; In Google Sheets: Format  Number

There are several buttons to control number format directly. These will apply that format to the select cell or range.

Both Excel and Google Sheets include buttons for:

  • Currency
  • Percentage
  • Increase / decrease decimal places
  • Other formats
Excel

For fuller control, right-click on the selected cell(s), choose Format Cells... and select an appropriate format from the Number tab.You can also get to these options from the Number Format "dialogue box launcher" on the ribbon.

Google Sheets

For fuller control, choose Format>Number..., or select from the More formats drop-down on the formatting tools bar.

Number formats remain in a cell when clearing values. This can lead to confusion when entering data  if a cell previously contained a date, entering the number 4 will produce the result 04/01/1900.
This is easily fixed by re-formatting the cell(s) (choose General if no special format is required).

Here's some useful information about numbers in spreadsheets:

Decimal places

Numbers are stored internally to 15 digits (e.g. 3.14159265358979) and the full value is used in calculations. The value displayed, however, will depend on the formatting chosen, and the usual rules of rounding will be applied.

Leading zeroes

Numbers are displayed without leading zeroes, even if entered that way. This can cause a problem with data such as phone numbers. However, phone numbers can safely be stored as text (since they are not used in calculations). To force a spreadsheet to treat cell content as text, enter a single quote (') first, e.g. '018118055 (the quote doesnt display).

Separators

Large numbers can be easier to read if separators are used to group the thousands (e.g. 1,000,000 instead of 1000000). In Google sheets, commas are included in the standard "Number" format, while in Excel there's a Use 1000 Separator (,) checkbox in the "Format Cells" dialogue box mentioned above.

Be aware that some countries use the comma as a decimal separator; try not to confuse people!

Other formats

Other options are available, including scientific notation and fractions. Dates, times, percentages, and currency are numbers with special formatting applied.

######

If a number is too wide for the column it is shown as a series of hashes, since truncating the value could be very misleading!

Video liên quan