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

[KenK]

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

thanks, Ken

 

[Sheeloo]

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

 

[ShaneDevenshire]

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.