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]

Reply via email to