Immanuel CRC Office wrote:
Matt Kinsel wrote:
Hi. I'm using OpenOffice.org 2.0 Beta on a Dell laptop running the
Fedora
Core 4 version of Linux. When I'm making a spreadsheet and type a
fraction
like "1/3" into one of the fields, it automatically converts it to a
date
like "01/03/2006". If I'm typing "4/5", it converts it to
"04/05/2006". It
does this for almost any fraction that can be converted to a date. Can
anyone tell me how to turn this feature OFF? Thank you very much for
your
help.
As you are not subscribed, you may not have seen:
Type =1/3 instead, because what you are trying to type is a formula, not
a fraction, and '=' forces Calc into formula entry mode. Calc doesn't
recognise fractions as such.
By the way, I tried formatting the cells as Numbers, but then Calc just
displays the date in it's internal floating point representation. I.e
1/3 becomes 38777.00
'Fractions' that can't be turned into dates are left as text.
Also, you could try typing '1/3 so that it recognizes the information
as text, not a date or fraction or anything. Add a ' to the beginning
of any cell will make it stay exactly as you type it.
Crystle
Select the cells you want to put fractions into => right click => Select
Format Cells => Select "Numbers" => Select "Fraction" from "Category" =>
Click "OK"
That will allow you to put fractions into those cells, (i.e., 24 1/3,
1/2, etc.).
Hope this helps.
Michael
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
