To display a number as years and months in Excel, you can use the INT and MOD functions. For example, if you have a cell that contains the number of months, you can use the formula =INT(A1/12) & " years, " & MOD(A1,12) & " months" to display the result as years and months.