I format a cell to percentage, then if I enter 0.5 to the cell it will
be 0.5% and if I enter .5 (no leading zero) it will be 50%, Is there
any way we can make 0.5 same as .5 without changing the format ? Thanks