| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
%s in XL entered as ".5" OR "50" reads as 50% if format is %age.
I have a spreadsheet I work with every day and I use fractional percentages,
between 0-1%. If the field is formatted as Percentage, and I type in ".5", it reads it as 50%, which it would be if it weren't a percentage. But it is. It's a half percent. By typing in "50", I also get 50%, which doesn't make sense. If I type in "5" I get 5%, if I type in ".5", I should get .5%. Is there a way to make this happen, or is this just a glitch in Excel? Please help me figure this out. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a auto date entered into a cell permanent from a template | Excel Discussion (Misc queries) | |||
| Protect data in cells after entered | Excel Discussion (Misc queries) | |||
| Formula Changes when data entered in referenced range | Excel Discussion (Misc queries) | |||
| Warn if already entered | Excel Worksheet Functions | |||
| showing the # of times an item is entered in a column | Excel Worksheet Functions | |||
Threaded Mode
