In the first data report (purple), I want Excel to tell me the number of units an employee has sold when I enter their ID and a week number. To achieve this, in cell H4, I'll type =OFFSET(B1,H2,H3) ...

If you enter 4/5, Excel will interpret the entry as a date and display it as a date, 4/5 or April 5. If you don’t realize it, that “date” will not evaluate as you expect.

Learn how to display Numbers as Fractions in Excel. ... Have you tried to enter a fraction into your Excel sheet, but when you press enter, it turns into a serial, ... Name * Email * Website.

To enter a negative value into a Microsoft Excel sheet, precede the value with a hyphen character, (-), which represents the “negative sign.” Often though, you won’t want to display that ...