Auto calc

1. 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. 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" <Jkalsch@discussions.microsoft.com> wrote in message news:1E53D7AC-239F-48CC-8CE6-A3AD6222A941@microsoft.com...
| 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. 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" <Jkalsch@discussions.microsoft.com> wrote in message news:1E53D7AC-239F-48CC-8CE6-A3AD6222A941@microsoft.com...
> | 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.
>
>
>

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

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