Paul Sims Wright wrote:
I'm using OOo 2 under Win XP. In Calc:
1. I format a column to be fractions. I enter 1/16 and hit enter.
The displayed value changes to 1/9. The decimal equivalent value is
correct. Whassup?
2, I want to change a list of values created by formula (A2=A1+1,
A3=A2+1, etc) into text versions of their true values. I figure the
TEXT function should do it but all I get is #Name. I figure I am
getting the format parameter wrong but nothing I try seems to work.
-----Paul-----
You have formatted the cell as ?/? (single digit over single digit)
You must format the cell as ??/?? (double digit over double digit)
Single digits are the first line in the format fraction choices.
Double digits are the second choice. Choose the second.
For what it is worth, you can even format the cell as ???/???
by defining it yourself. If you do that, then you can get
=pi() to show up as 355/113 if you like. Try it.
Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
