Best Answer

You should type in the year using 4 digits when entering a date instead of entering just 2 digits for the year. This is because anything from 00 to 29 is taken as being the years 2000 to 2029. Anything from 30 to 99 is taken as being as being 1930 to 1999. You need to enter 4 digits if the year is outside of these ranges. So, for example, if you want your date to be the 1st of January 1920, then typing 1/1/20 will not work, as it will treat it as the year 2020. So you need to type 1/1/1920 instead. You should also make sure the cell is in a date format.

Q: How do you ensure that Excel interprets year values the way you intend?

Write your answer...

Submit

Still have questions?

Related questions

When you enter a two-digit year value, Excel changes a two-digit year less than 30 to 20xx and a two-digit year of 30 and greater to 19xx. Use four-digit years to ensure that Excel interprets year values the way you intend, if necessary.

That is not a common Excel term, but it probably is a format you do not intend to print.

The MIN function.

It formats the values.

Excel allows you to change values in a worksheet quickly and easily. How is this helpful in running a business? How can changing values affect business decisions?

Arguments

The AVERAGE function.

This question is not clear and does not appear to have anything to do with Microsoft Excel. Please ask again using words that make it clear what you want to know and ensure the question is in an appropriate category.

There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.

The 'sum' function.Type =sum(X,Y) - bold for emphasis - where X and Y are your cell locations or values, and Excel will return the sum (i.e. the result of addition) of those values.

The ___________ allows you to use excel to change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values.

It is possible to design an invoice in Excel and get it to have the values that you need. It can then be printed and sent to a customer.