Thread: Year
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jose Jose is offline
external usenet poster
 
Posts: 35
Default 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