J
JoeC.nc
Hi All,
I came upon an excel issue that, performing a web search, I do not
find documented anywhere.
When decimal numbers are displayed as fraction using Format-->Fraction
(up to one digit), Excel selects the closest available fraction
(supposedly).
However it doesn't do it correctly.
eg
0.1 displays as 0 rather than 1/9
1.3 displays as 1 1/3 rather than 1 2/7
Values between 0.2308 and 0.2361 display as 1/4 rather than 2/9.
I am aware that these display values are not used in calculations, but
what the hell? Excel should be selecting the closest available
fraction, no??
I believe that this issue is a bug, and not a Bin-->Dec artifact.
BTW, Excel 2000 & 2002...don't know about other versions.
Joe C
I came upon an excel issue that, performing a web search, I do not
find documented anywhere.
When decimal numbers are displayed as fraction using Format-->Fraction
(up to one digit), Excel selects the closest available fraction
(supposedly).
However it doesn't do it correctly.
eg
0.1 displays as 0 rather than 1/9
1.3 displays as 1 1/3 rather than 1 2/7
Values between 0.2308 and 0.2361 display as 1/4 rather than 2/9.
I am aware that these display values are not used in calculations, but
what the hell? Excel should be selecting the closest available
fraction, no??
I believe that this issue is a bug, and not a Bin-->Dec artifact.
BTW, Excel 2000 & 2002...don't know about other versions.
Joe C