Create a helper column in column B, for example. Assuming your data is in
column A, enter the following formula in B1 = IF(A1,1,0) drag the formula
down column B as far as necessary. When you're satisfied the result in
column B is correct, delete column A.

Tyro


"Charles" wrote in message
news:FA93245B-4B45-47CF-897E-4E5AC4DBC7FC@microsoftom...
I have a data set with percent values ranging from 0 to 1. I want to
replace
all numbers greater than 0 to 1 in order to convert my data set to
presence/absence. How do I do this?