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.

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" <(E-Mail Removed)> wrote in message news:1E53D7AC-239F-48CC-8CE6-(E-Mail Removed)...
| 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.

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" <(E-Mail Removed)> wrote in message news:1E53D7AC-239F-48CC-8CE6-(E-Mail Removed)...
> | 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.
>
>
>