Also, try entering the value as a formula. E.g., "=5/32" (without quotes), so that the result is required to be numeric. Then the Fraction formatting will also work.
> -----Original Message----- > From: Wade Smart [mailto:[email protected]] > Sent: Tuesday, June 28, 2016 07:41 > To: [email protected] > Subject: Re: problem with fractions in spreadsheet. > > Right click in the cell. Select Format. > In the window that comes up, left Tab Numbers, > in the Category if you scroll down you can select Fraction. > It will now look like a fraction when you write 6 1/3. > > > > -- > Registered Linux User: #480675 > Registered Linux Machine: #408606 > Linux since June 2005 > > On Tue, Jun 28, 2016 at 9:26 AM, Vincent A. Juliano > <[email protected] <mailto:[email protected]> > wrote: > > > Thank you Wade for the reply. Now on to the question. > > Whenever I’ve entered a fraction or a mixed number into my > spreadsheet, upon hitting the enter button, the fraction immediately > changes into a date. > > For example I enter 5/32, upon hitting Enter the fraction shows up > in the cell as 05/01/32. Should I enter 6-1/3 it will show as 6 1/3. > However the screw size 4-40 will show as 04/01/40. 6 11/16 shows as 6 > 2/3. This is not accuracy that is possible to use. > > How can I get the spreadsheet to enter the fractions and mixed > numbers as written? > Format -Numbers-Fractions yields no better results. > > Please spell out the suggested solutions as simply as possible. I > am definitely NOT computer savvy > > Thank you for any help or suggestions. > > Vince > > > > > > Vincent Juliano > [email protected] <mailto:[email protected]> > > > > On Jun 28, 2016, at 8:43 AM, Wade Smart <[email protected] > <mailto:[email protected]> > wrote: > > > Vincent, you just have to ask your question. > Someone will respond. > > -- > Registered Linux User: #480675 > Registered Linux Machine: #408606 > Linux since June 2005 > > On Tue, Jun 28, 2016 at 7:38 AM, Vincent A. Juliano > <[email protected] <mailto:[email protected]> > wrote: > > > What is the proper email address to get help for open > office. > > Using Open office since version 2.0 and forgot almost > everything, > > Thank you > Vince > > Vincent Juliano > [email protected] <mailto:[email protected]> > > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
