Thread: How can I display a batting average as .333 rather than 0.333?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How can I display a batting average as .333 rather than 0.333?
At bats in A1

Hits in B1

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


Gord Dibben MS Excel MVP


On Mon, 29 Oct 2007 11:44:01 -0700, ernie d <ernie
wrote:


Reply With QuoteReply With Quote