Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I display a batting average as .333 rather than 0.333?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I display a batting average as .333 rather than 0.333?
For future reference, it is considered rude to ask your question in the
Subject line. Try custom formatting the cells using .000 as the pattern. Rick |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I display a batting average as .333 rather than 0.333?
Use a custom format of .000
Select the cells in question Goto FormatCellsNumber tab Select Custom In the little box under Type: enter .000 OK out -- Biff Microsoft Excel MVP "ernie d" <ernie wrote in message ... |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I display a batting average as .333 rather than 0.333?
Too easy<g
Gord On Mon, 29 Oct 2007 15:05:21 -0400, "Rick Rothstein \(MVP - VB\)" wrote: Try custom formatting the cells using .000 as the pattern. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I display a batting average as .333 rather than 0.333?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hOW TO USE EXCEL TO CALCULATE BASEBALL BATTING AVERAGE | Excel Worksheet Functions | |||
What function would let me find Batting Averages? | Excel Worksheet Functions | |||
What function would let me find Batting Averages? | Excel Worksheet Functions | |||
What function would let me find Batting Averages? | Excel Worksheet Functions | |||
What function would let me find Batting Averages? | Excel Worksheet Functions |