View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default how to drop leading zero in 0.700? desired result is .700

Custom format the cells as .##

Format Cells|Custom|Type .000 to see numbers like .340, .200..

If you use .### instead then Exxcel will not add 0 if you enter .2
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"KenK" wrote:

when calculated something like a baseball hitting percentage, how do you drop
the leading zero in the number....0.350 versus .350

thanks, Ken