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

  • Thread starter Rick Rothstein \(MVP - VB\)
  • Start date
R

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

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
 
G

Gord Dibben

At bats in A1

Hits in B1

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


Gord Dibben MS Excel MVP
 
Top