| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting for innings pitched
I'm sure all you baseball fans have got an easy solution to this one:
I've got fractions of innings pitched as .333333, or .6666667. I want them to appear in the report as .1 or .2. So far, I've been converting them back and forth, one for the report, and the other for calculations. I would sure rather just change the FORMATTING, so that the cell just shows a .1 or .2, but still retains its original calculated innings pitched. How do I do that? 180.6666667 would APPEAR on the report as 180.2 Thanks! I'm using Excel 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| Formatting dates in the future | Excel Worksheet Functions | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
