Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Options
How do you disable the rounding feature in excel (e.g. - I want to display
10/6, and not 5/3 as excel would display)? |
#2
|
|||
|
|||
One way:
Format/Cells/Number/Custom ?/6 In article , "todd" wrote: How do you disable the rounding feature in excel (e.g. - I want to display 10/6, and not 5/3 as excel would display)? |
#3
|
|||
|
|||
text format
|
#4
|
|||
|
|||
Thanks for the help. Let me take this question one step further. I want to
create a bar graph that displays the fractional value taken from a table. The caveat is that the denominator of my data set varies from one data point to the next, which prevents the use of format/cells/number/custom ?/(common denominator). For example, my data may look like this: 10/6; 2/1; 8/9; 1/1; 0/0; 0/0; etc. The Custom Data Label Format allows the entire data set to be normalized to one common denominator. "todd" wrote: How do you disable the rounding feature in excel (e.g. - I want to display 10/6, and not 5/3 as excel would display)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
Problems with Excel Horizontal arrays with regional options using. | Excel Discussion (Misc queries) | |||
Excel Send To Options | Excel Discussion (Misc queries) |