On Fri, 2006-03-03 at 10:08 -0800, Michael J. Reude wrote: > 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.).
Aha. Learning all the time... but there seems to be a bug in this feature. It works for 1/3, 1/8, etc. but 1/2 and 1/4 are converted to text, so that attempts to reference that cell value return 0. Someone forgot to turn the autocorrect functions off for non-text cells. You will need to turn that feature off in Tools - AutoCorrect - Options. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
