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
|