T
todd
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)?
10/6, and not 5/3 as excel would display)?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
One way:
Format/Cells/Number/Custom ?/6
Format/Cells/Number/Custom ?/6
º
º¼ÖÝÈË
text format
T
todd
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.
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.