You'd have to re-enter as a percentage.

Insted of typing 70 (for 70%) type either .7 or 70%.

--
Biff
Microsoft Excel MVP


"SJT" wrote in message
...
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?