how to drop leading zero in 0.700? desired result is .700
 

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

thanks, Ken

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

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