When i select a % in my dynamic view drop down in the source sheet it doesnt come through right

Suzanne Burton

When i select a % in my dynamic view drop down in the source sheet it doesn't come through right so my formula doesn't work when referencing the % field.

you will see the % come in set to the left so when i reselect the % out of the drop down they format to the right and then the formula works. How can i resolve this so i don't have to do any manual entry

Paul Newcome

Try making it manual entry instead of a dropdown. If you NEED to use the dropdown, you can amend your formulas with a VALUE/SUBSTITUTE combo to strip out the "%" and convert it into a numerical value.