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
|