Year
Roger and Bob, It works
--
Many thanks for your help,
Jose
"Roger Govier" wrote:
Hi
Select the cell with your formula, FormatCellsNumberCustom 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.
--
Regards
Roger Govier
"Jose" wrote in message
...
I have a small formula calculation which results in 2.6. How can I add
'2.6
year'
--
Many thanks for your help,
Jose
|