I have four cells across that must equal 100%. In the fourth cell I have a
data validation formula such as =sum(A1:D1)=1. So in this case the
validation formula is in D1 and there is an error message that tells the user
the sum of the cells is not 100%. All of the cells are formatted for %.
However, in the event that the last cell does not get the sum to 100% and I
hit retry and insert the proper number I am still getting an error message.
It appears to want to put the number in as a general number instead of a
percentage. Any thoughts on how I could resolve this?