Thread: How can I display a batting average as .333 rather than 0.333?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default 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

Reply With QuoteReply With Quote