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

Hi,

Select the cells and choose Format, Cells, Number tab, Custom and enter the
following code in the Type box
..000
or
..###
or as many decimal places as you want to see.

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"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