| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make table query will work in datasheet view but will not make tab | Excel Discussion (Misc queries) | |||
| How do I make make comment format default? | Excel Discussion (Misc queries) | |||
| make macros usable! make instructions in plain english !!!! | Excel Worksheet Functions | |||
| How do I make each row add up seperatly? Please make it easy... | New Users to Excel | |||
| how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
Linear Mode
