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.
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" <[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.
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.
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks