Thread: when displaying a batting average, how do I hide the 0 in 0.xxx?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default when displaying a batting average, how do I hide the 0 in 0.xxx?
Give the cell/range a custom format of .000

In xl2003
select the range
format|cells|number category
Custom
in the type
..000

And click ok.

ernie d wrote:

--

Dave Peterson
Reply With QuoteReply With Quote