Hi,
I have a number in cell A1 which is 2.02. I am using the formula =TEXT(A1,"##.#")&" years" to show that I have 2.0 years.
However, when the number is something that should be rounded to a number with a zero after it the result just says 2. years instead of 2.0 years. I don't get the zero following the number like I think I should. It works for all other values just fine.
Don't know what I am doing wrong. I am using Excel 2010 on W7. Thx.
I have a number in cell A1 which is 2.02. I am using the formula =TEXT(A1,"##.#")&" years" to show that I have 2.0 years.
However, when the number is something that should be rounded to a number with a zero after it the result just says 2. years instead of 2.0 years. I don't get the zero following the number like I think I should. It works for all other values just fine.
Don't know what I am doing wrong. I am using Excel 2010 on W7. Thx.