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
--
Crystle Numan
Administrative Secretary, Immanuel CRC
61 Mohawk Rd. W. Hamilton ON L9C 1V9
905-385-0662
[EMAIL PROTECTED]
http://immanuelministries.ca
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
