How to make 0.5 same as .5
 

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

How to make 0.5 same as .5
 

It's for that very reason I don't format anything as percentage.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"broogle" wrote in message
ups.com...
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

How to make 0.5 same as .5
 

I meant to also say.
From Tools | Options | Edit | Untick Enable automatic percent entry

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Rob van Gelder" wrote in message
...
It's for that very reason I don't format anything as percentage.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"broogle" wrote in message
ups.com...
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