Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Excel Simple Question - I hope

Thread Tools
 
Search this Thread
 
Old 08 February 2004, 12:34 PM
  #1  
farmer1
Scooby Regular
Thread Starter
 
farmer1's Avatar
 
Join Date: Feb 2004
Posts: 1,785
Likes: 0
Received 0 Likes on 0 Posts
Default Excel Simple Question - I hope

How do I get excel to show a real number as a fraction

For example how do I get it to show 0.166666666 as 1/6?

I have set up a table with two variables to come up with an example and I need them as fractions rather then decimal.

any help greatly appreciated
Old 08 February 2004, 12:35 PM
  #2  
farmer1
Scooby Regular
Thread Starter
 
farmer1's Avatar
 
Join Date: Feb 2004
Posts: 1,785
Likes: 0
Received 0 Likes on 0 Posts
Default

Its Ok I found it now I had to format cell and select fraction.
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Frizzle-Dee
Essex Subaru Owners Club
13
01 December 2015 09:37 AM
PetrolHeadKid
Driving Dynamics
10
05 October 2015 05:19 PM
bluebullet29
General Technical
9
05 October 2015 02:17 PM
Phil3822
ScoobyNet General
33
02 October 2015 03:22 AM
joe v3sti
ScoobyNet General
2
28 September 2015 08:59 AM



Quick Reply: Excel Simple Question - I hope



All times are GMT +1. The time now is 10:49 PM.