| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel 2003 display 8/16 as 1/2 and 4/16 as 1/4
I have a large spreadsheet in which I wish to display fractional values up to
16ths. I want the fractions to round down to the lowest denominator. For instance 8/16 should display as 1/2 and 10/16 should display as 5/8. The spreadsheet is too large to go through and individually change the format cell by cell. Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel 2003 display 8/16 as 1/2 and 4/16 as 1/4
By default, XL does display the LCD.
How are you entering your fractions? Try: 0<space8/16 And see what you get. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Terry Kappler" <Terry wrote in message ... I have a large spreadsheet in which I wish to display fractional values up to 16ths. I want the fractions to round down to the lowest denominator. For instance 8/16 should display as 1/2 and 10/16 should display as 5/8. The spreadsheet is too large to go through and individually change the format cell by cell. Can anyone help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel 2003 display 8/16 as 1/2 and 4/16 as 1/4
"Terry Kappler" wrote: I have a large spreadsheet in which I wish to display fractional values up to 16ths. I want the fractions to round down to the lowest denominator. For instance 8/16 should display as 1/2 and 10/16 should display as 5/8. The spreadsheet is too large to go through and individually change the format cell by cell. Can anyone help? Actually I am entering formulas with the results displayed as fractions. I was able to round to 16ths and format the cells in ##/## and it worked fine. Thanks for the response. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Always display a particular worksheet upon opening Excel 2003 | Excel Discussion (Misc queries) | |||
| how do i display menu bar in Excel 2003? | Excel Discussion (Misc queries) | |||
| Excel 2003 - How to display 761000 in a cell as 761 | Excel Worksheet Functions | |||
| Excel 2003: date display issue | Excel Discussion (Misc queries) | |||
| my excel 2003 has no menu bar. how do I display it? | Setting up and Configuration of Excel | |||
Linear Mode
