On Fri, 2006-03-03 at 10:10 -0500, 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 >
I beg to differ. Simply set the cell format to fractions. There are two styles. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
