"*" <*@*.*> wrote in message
news:...
> Hi Buckaroo Banzai, You told me:
>> "Buckaroo Banzai" <> wrote in message
>> news:N8x3e.8326$ ...
>>>
>>> "John" <> wrote in message
>>> news:...
>>>> On Sat, 02 Apr 2005 10:53:28 +0100, A strange species called John
>>>> <> wrote:
>>>>
>>>>> Hello.
>>>>>
>>>>> I don't supposed anyone knows how to display a decimal number in
>>>>> excel in years and months to the nearest month?
>>>>>
>>>>> For example, I may have the figure 6.75. We know it should be 6
>>>>> years and 9 months, but how do I get excel to display it like that?
>>>>>
>>>>> I am guessing I may need to use the DATEIF function?
>>>>>
>>>>> Thanks for any help
>>>>>
>>>>> John
>>>>
>>>> Its okay. Worked this one out now. Quite a toughie.
>>>>
>>>> John
>>>>
>>>
>>> Too bad... you'd for sure have gotten the right answer tuit suite
>>> considering you posted the question to a Howard Stern NG....
>
>> Sorry! I thought I was in the Howard Stern NewsGroup... my bad!
>
> BWAHAHAHAHAHAHAHAHAHAA! You ****tard ****.
Hey, when I mess up, I mess up- so for today, I *am* a '****tard ****'.....
|
Similar Threads
