I have a cell that has a format of Percentage with 1 decimal. I want to
add data validation to that cell so that it only allows between 0% and
100%. I set up some data validation to allow decimal between 0 and
100. When I type a number in that cell, such as 344, it automatically
adds the % sign to the end and it allows that number. Is there a way
to fix this?


--
LAF
------------------------------------------------------------------------
LAF's Profile: http://www.excelforum.com/member.php...fo&userid=9656
View this thread: http://www.excelforum.com/showthread...hreadid=469272