Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get excel to NOT auto reduce fractions.
Part 1) I'm trying to enter data as a fraction, but excel auto reduces the
fraction. It's for basketball, attempts/made. Example... 2/4 is 2 shots made out of 4, but when I put in 2/4 it turns to 1/2, and so on with other entries. Part 2) After I get that working I need to add the fractions, with out them becoming whole numbers and what not. If all this isn't possible, I can just use two seperate columns, but I hope this can work. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get excel to NOT auto reduce fractions.
If you put that data in separate fields, you're life will be much easier.
You'll be able to determine percentages easier. You'll be able to get team stats easier. I've found it always better to put different information in different fields/columns. Jason wrote: Part 1) I'm trying to enter data as a fraction, but excel auto reduces the fraction. It's for basketball, attempts/made. Example... 2/4 is 2 shots made out of 4, but when I put in 2/4 it turns to 1/2, and so on with other entries. Part 2) After I get that working I need to add the fractions, with out them becoming whole numbers and what not. If all this isn't possible, I can just use two seperate columns, but I hope this can work. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get excel to NOT auto reduce fractions.
Thanks Dave, that's what I thought I'd have to do.
"Dave Peterson" wrote: If you put that data in separate fields, you're life will be much easier. You'll be able to determine percentages easier. You'll be able to get team stats easier. I've found it always better to put different information in different fields/columns. Jason wrote: Part 1) I'm trying to enter data as a fraction, but excel auto reduces the fraction. It's for basketball, attempts/made. Example... 2/4 is 2 shots made out of 4, but when I put in 2/4 it turns to 1/2, and so on with other entries. Part 2) After I get that working I need to add the fractions, with out them becoming whole numbers and what not. If all this isn't possible, I can just use two seperate columns, but I hope this can work. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reduce fractions into lowest terms? | Excel Discussion (Misc queries) | |||
how to reduce line space in excel | Excel Discussion (Misc queries) | |||
HOW DO I REDUCE THE SIZE OF A EXCEL FILE (EX: 4MB - 1MB) | Setting up and Configuration of Excel | |||
Reduce processing load in Excel | Excel Discussion (Misc queries) | |||
fractions in excel | Excel Discussion (Misc queries) |