| 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? |
| 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 | |||
Threaded Mode
