Hi there,
My question:
How do I restrict the user from manually typing the "%" symbol in a cell??
Background:
I'm trying to finish a basic user form (with drop-down lists) where:
- if option 1 is chosen in cell A1, then cell A2 is formatted in Accounting format.
- if option 2 is chosen in cell A1, then cell A2 is formatted in Percentage format.
I set the above up easily with a Custom format in conditional formatting so that when option 2 is chosen, it shows as % format (even though the cells default is Accounting).
BUT, if the user chooses option 1 and manually enters a "%" it changes the default format from Accounting to an actual %, which I don't want (i.e. option 1 should only allow Accounting format).
I made a weak workaround by putting data validation so regardless of which option's chosen, it must be > 1. This limits me though since there are instances where option 1 is chosen and it's legitimately $0.50 or something < 1.
Bottom line: how do I restrict the user from manually typing the "%" symbol??
Sorry for long msg if you need a sample just let me know!
Cheers,
James
My question:
How do I restrict the user from manually typing the "%" symbol in a cell??
Background:
I'm trying to finish a basic user form (with drop-down lists) where:
- if option 1 is chosen in cell A1, then cell A2 is formatted in Accounting format.
- if option 2 is chosen in cell A1, then cell A2 is formatted in Percentage format.
I set the above up easily with a Custom format in conditional formatting so that when option 2 is chosen, it shows as % format (even though the cells default is Accounting).
BUT, if the user chooses option 1 and manually enters a "%" it changes the default format from Accounting to an actual %, which I don't want (i.e. option 1 should only allow Accounting format).
I made a weak workaround by putting data validation so regardless of which option's chosen, it must be > 1. This limits me though since there are instances where option 1 is chosen and it's legitimately $0.50 or something < 1.
Bottom line: how do I restrict the user from manually typing the "%" symbol??
Sorry for long msg if you need a sample just let me know!
Cheers,
James