Chat with our AI personalities
if a cell has a two-digit year of 32 excel automatically changes it to a four-digit year
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.
one tenth of 9 years = 0.9 year or 10.8 months 1/10 * 9 years = 0.9 year * 12 months/1 year = 10.8 months
maths
February