J
Jose
I have a small formula calculation which results in 2.6. How can I add '2.6
year'
year'
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob I
=your formula calculation & " year"
J
Jose
Bob, Thanks it works. What can I do so it shows only 2 decimals
R
Roger Govier
Hi
Select the cell with your formula, Format>Cells>Number>Custom> General "
Years"
The result will show as 2.6 Years, but the value in the cell will still be
numeric, allowing you to use it in further calculations.
Select the cell with your formula, Format>Cells>Number>Custom> General "
Years"
The result will show as 2.6 Years, but the value in the cell will still be
numeric, allowing you to use it in further calculations.
J
Jose
Roger and Bob, It works
--
Many thanks for your help,
Jose
--
Many thanks for your help,
Jose
Roger Govier said:Hi
Select the cell with your formula, Format>Cells>Number>Custom> General "
Years"
The result will show as 2.6 Years, but the value in the cell will still be
numeric, allowing you to use it in further calculations.