Q. When I paste a large amount of data into Excel containing dates as far back as the 1800s, the recent dates display correctly as valid dates, but the older dates automatically convert to text. I ...
Office solution: Clearing up that wacky date problem when copying sheets Your email has been sent This week, learn the solution to the last Office challenge: Why does Excel change dates when I copy a ...
Q. Help! My future value calculations don’t make any sense (see the spreadsheet below). The formula in column D is the same for all rows, but for unknown reasons, it stops working after row 7. What’s ...