How to make 0.5 same as .5

  • Thread starter Thread starter broogle
  • Start date Start date
B

broogle

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
 
I meant to also say.
From Tools | Options | Edit | Untick Enable automatic percent entry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding to nearest .5 in vba 12
Is this a bug in excel 2007 charting 9
Date conversion doesn't make sense 3
problem with percentage in cells 4
page setup preferances 1
Macro, how to set a cell value to zero 1
rotation of an arrow created by an drawing object 6
If statement; How to do something similar to - if(a1-a2>=5,+5) 6

Back
Top