Re: Excel formula help

Discussion in 'Computer Support' started by *, Apr 2, 2005.

  1. *

    * Guest

    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 fucktard ****.
    *, Apr 2, 2005
    #1
    1. Advertising

  2. "*" <*@*.*> 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 fucktard ****.


    Hey, when I mess up, I mess up- so for today, I *am* a 'fucktard ****'.....
    Buckaroo Banzai, Apr 2, 2005
    #2
    1. Advertising

  3. *

    Dr. Bill Guest

    Buckaroo Banzai wrote:
    > I *am* a 'fucktard ****'.....


    Nice sig!
    Dr. Bill, Apr 2, 2005
    #3
  4. Dr. Bill wrote:
    > Buckaroo Banzai wrote:
    > > I *am* a 'fucktard ****'.....

    >
    > Nice sig!


    --
    hmmmm... dumb...
    * * * Y o u r . S h e p h e r d . A q u i , Apr 2, 2005
    #4
  5. "Dr. Bill" <> wrote in message
    news:d2nj6r.36k.1@133.256.1.103.MISMATCH...
    > Buckaroo Banzai wrote:
    >> I *am* a 'fucktard ****'.....

    >
    > Nice sig!


    ....c'mon now. I only meant this time.
    Buckaroo Banzai, Apr 3, 2005
    #5
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Doug

    Excel 2003 Formula

    Doug, Feb 15, 2004, in forum: Microsoft Certification
    Replies:
    0
    Views:
    534
  2. =?Utf-8?B?QyBBbmRlcnNvbg==?=

    Excel Formula

    =?Utf-8?B?QyBBbmRlcnNvbg==?=, Apr 12, 2006, in forum: Microsoft Certification
    Replies:
    1
    Views:
    553
    Carey Frisch [MVP]
    Apr 12, 2006
  3. Max Sand

    Excel formula for this...

    Max Sand, Sep 2, 2003, in forum: Computer Support
    Replies:
    6
    Views:
    626
  4. John

    Excel formula help

    John, Apr 2, 2005, in forum: Computer Information
    Replies:
    10
    Views:
    631
    Buckaroo Banzai
    Apr 3, 2005
  5. Steve Freides

    Need some Excel formula help

    Steve Freides, Sep 18, 2007, in forum: Computer Support
    Replies:
    8
    Views:
    638
Loading...

Share This Page