Am Sonntag, 18. Dezember 2005 00:38 schrieb Chris BONDE:
> Am Samstag, 17. Dezember 2005 18:26 schrieb Joe Conner:
> > It is unreliable. :-(
> > For example, put in a cell "=5/17"
> > then format the cell as a fraction.
> > It will give you 2/7. This is
> > close, but no cigar!
>
> It's all a m
Am Sonntag, 18. Dezember 2005 00:38 schrieb Chris BONDE:
> Am Samstag, 17. Dezember 2005 18:26 schrieb Joe Conner:
> > It is unreliable. :-(
> > For example, put in a cell "=5/17"
> > then format the cell as a fraction.
> > It will give you 2/7. This is
> > close, but no cigar!
>
> It's all a mat
Interesting. Thanks.
I input into a cell " =pi() "
and formatted as #???/???
and it fed out 355/113. This
is accurate to about 1 part in
3.75 million.
Joe
Chris BONDE wrote:
Am Samstag, 17. Dezember 2005 18:26 schrieb Joe Conner:
It is unreliable. :-(
For example, put in a
Am Samstag, 17. Dezember 2005 18:26 schrieb Joe Conner:
> It is unreliable. :-(
> For example, put in a cell "=5/17"
> then format the cell as a fraction.
> It will give you 2/7. This is
> close, but no cigar!
It's all a matter of formatting, i.e. display. Put more "?" in >
Format > Cell > For
On Sat, 2005-12-17 at 09:26 -0800, Joe Conner wrote:
> It is unreliable. :-(
> For example, put in a cell "=5/17"
> then format the cell as a fraction.
> It will give you 2/7. This is
> close, but no cigar!
>
> Joe
>
Try the expanded format. Worksforme.
[snipped]
--
PLEASE KEEP MESSAGES O
Am Samstag, 17. Dezember 2005 18:26 schrieb Joe Conner:
> It is unreliable. :-(
> For example, put in a cell "=5/17"
> then format the cell as a fraction.
> It will give you 2/7. This is
> close, but no cigar!
It's all a matter of formatting, i.e. display. Put more "?" in > Format > Cell
> Form
It is unreliable. :-(
For example, put in a cell "=5/17"
then format the cell as a fraction.
It will give you 2/7. This is
close, but no cigar!
Joe
G. Roderick Singleton wrote:
On Sat, 2005-12-17 at 09:33 -0500, Andrew Douglas Pitonyak wrote:
klaus schmirler wrote:
Andrew Douglas Pitonyak wrote:
If you need to display a number as a fraction, I have a macro that will
convert to and from fraction formats. Klaus, are you saying that there
is a number format to display a decimal number as a fraction. I think
that the answer is no, but would be very happy
On Sat, 2005-12-17 at 09:33 -0500, Andrew Douglas Pitonyak wrote:
> klaus schmirler wrote:
>
> > Terry North wrote:
> >
> >> I think people may be talking about different subjects.
> >
> >
> > Obviously. Going back to the original posting, he talks about a
> > "quotient function", but he also wa
klaus schmirler wrote:
Terry North wrote:
I think people may be talking about different subjects.
Obviously. Going back to the original posting, he talks about a
"quotient function", but he also wants a "simple fraction", which is
not what the quotient function does.
Fractions are just
Terry North wrote:
I think people may be talking about different subjects.
Obviously. Going back to the original posting, he talks about a
"quotient function", but he also wants a "simple fraction", which is
not what the quotient function does.
Fractions are just a formatting thing: right
klaus schmirler online.de> writes:
> Dan Lewis wrote:
>
> > One slight modification: your system would probably show it this way
> > =0,/0, results in 0,5.
>
> It doesn't, but then it shouldn't because QUOTIENT is supposed to
> return the integer part only. So the result is 0.
Dan Lewis wrote:
One slight modification: your system would probably show it this way
=0,/0, results in 0,5.
It doesn't, but then it shouldn't because QUOTIENT is supposed to
return the integer part only. So the result is 0.
klaus
--
13 matches
Mail list logo