Data Validation
 

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

I think you need to limit your input to numbers between 0 and 1.0
(100%=1)

Then an entry keyed in as "99" will return 99%

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=469272

It worked! Thank you!


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