+ Reply to Thread
Results 1 to 3 of 3

Auto calc

  1. #1
    Jkalsch
    Guest

    Auto calc

    When i enter a fraction as 10/5 it automatically calculates it to 2. Is there
    a way to automatically calculate something like 2.89/5 and have it calculate
    it as .578? Any help is greatly appreciated.

  2. #2
    Niek Otten
    Guest

    Re: Auto calc

    If you enter 10/5 in most settings of Excel that would be interpreted as a date, like May 10.
    If you enter =10/5 it would be interpreted as a formula and show the result, 2.
    If you enter =2.89/5 you'll probably see .578

    --
    Kind regards,

    Niek Otten

    "Jkalsch" <[email protected]> wrote in message news:[email protected]...
    | When i enter a fraction as 10/5 it automatically calculates it to 2. Is there
    | a way to automatically calculate something like 2.89/5 and have it calculate
    | it as .578? Any help is greatly appreciated.



  3. #3
    Jkalsch
    Guest

    Re: Auto calc

    Thanks Nick that works perfectly, that will be a real time saver.

    "Niek Otten" wrote:

    > If you enter 10/5 in most settings of Excel that would be interpreted as a date, like May 10.
    > If you enter =10/5 it would be interpreted as a formula and show the result, 2.
    > If you enter =2.89/5 you'll probably see .578
    >
    > --
    > Kind regards,
    >
    > Niek Otten
    >
    > "Jkalsch" <[email protected]> wrote in message news:[email protected]...
    > | When i enter a fraction as 10/5 it automatically calculates it to 2. Is there
    > | a way to automatically calculate something like 2.89/5 and have it calculate
    > | it as .578? Any help is greatly appreciated.
    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1