How can I display a batting average as .333 rather than 0.333?

[Guest]

 

[Rick Rothstein \(MVP - VB\)]

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

 

[T. Valko]

Use a custom format of .000

Select the cells in question
Goto Format>Cells>Number tab
Select Custom
In the little box under Type: enter .000
OK out

 

[Gord Dibben]

At bats in A1

Hits in B1

In C1 enter =TEXT(B1/A1,".000")


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Too easy<g>


Gord

 

[Gary]

Try formatting the cell to Text and then delete 0.