#1   Report Post  
todd
 
Posts: n/a
Default 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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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   Report Post  
ΊΌΦέΘΛ
 
Posts: n/a
Default

text format


  #4   Report Post  
todd
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
how to convert GETPIVOTDATA from excel 2000 to excel 2002... Need_help_on_excel Excel Worksheet Functions 1 March 15th 05 01:08 AM
I get a program error when I download an excel template Ladybug Excel Discussion (Misc queries) 3 March 4th 05 12:02 AM
Problems with Excel Horizontal arrays with regional options using. Dr. Strangelove Excel Discussion (Misc queries) 0 January 6th 05 03:41 PM
Excel Send To Options webeustoo Excel Discussion (Misc queries) 1 December 10th 04 03:39 PM


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"