When you enter a date that's formatted with slashes, Excel will recognize it as a date. For example, Excel will automatically choose the date format for a cell that contains 11/11/19. You can set ...

When you enter a date in one format on a Microsoft Excel worksheet and then want to change the order of the day, month and year, try accessing the Format Cells options. Update the format to help make ...

The cells in a Microsoft Excel spreadsheet can hold various types of numerical data, including fractions and percentages. If some or all of your cells contain fractions, Excel enables you to convert ...

Although Google Sheets and Excel Online are two of the best free online spreadsheet editing apps, you may not like certain features of them. For example, the date format. In case you do not want to ...

Have you ever opened your spreadsheet only to find your carefully typed numbers missing their decimals, or worse, transformed into something like 2.95E+07? If yes, you’ve seen the downside of relying ...

Excel Conditional Formatting already lets you format cells based on the value of those cells or the value of the formulas in those cells (see our conditional formatting tutorial for more details). Now ...

It’s not hard to add an alternating band format to a table by applying a table style. It’s quick and easy, but it’s limited. You’ll get a single-row fill color that alternates with a row of white (or ...

Use a custom format in Microsoft Excel to reduce the number of digits in a large number without losing its scale. Large numbers are a bit laborious to read, especially if there are many of them. To ...

Please note: This item is from our archives and was published in 2016. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I can’t figure out ...