Learn to create and add conditional formatting rules, including using formulas, with this workbook full of examples.

Learn what features are supported in Excel when you work with file formats OpenDocument (.ods) and Excel for Windows (.xlsx).

Learn how to use WORKDAY function in Excel to calculate invoice due dates, delivery times, or workdays excluding weekends or holidays.

Available number formats in Excel Article; Conditional Formatting Article; Align or rotate text in a cell Article; Change the format of a cell Article; Copy cell formatting Article; Add a watermark in Excel Article; Display or hide zero values Article; Create a custom number format Article

Apply the Date format with the day, month, and year. Ctrl+Shift+Number sign (#) Apply the Time format with the hour and minute, and AM or PM. Ctrl+Shift+At sign (@) Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. Ctrl+Shift+Exclamation point (!) Open the Insert hyperlink dialog box ...

For instance, cell A1 is formatted as currency, but a linked cell with =A1 is formatted as a date. ... If you select the Update format option, Excel will automatically apply the source cell's format for you. You can change this setting in File > Options > Formulas > Misleading number formats. ...

The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. ... Because the date is returned as a number, we use the TEXT function to format it as a date. The INDEX function actually uses the result of the MATCH function as its argument.

How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.

Depending on the format of the cells that contain the formulas that you entered, Excel might display the results as serial numbers. For example, 8-Feb-2019 might be displayed as 43504. Excel stores dates as sequential serial numbers so that they can be used in calculations.

Increase the decimal places for a lot of numbers at once. If you have a lot of numbers that have been rounded, or to prevent numbers from appearing as rounded at all, you can increase the decimal places of a number format and then apply it to the numbers in your worksheet.