Are you wanting to do this "in place" or do you need a formula in a
different cell?

Formula in a different cell:

=IF(ISNUMBER(A1),IF(A1=0,1,A1),"")

Biff

"Rob" wrote in message
...
Hi,

I have a column where some values contain 0 (zero). I want to create an IF
function, where, IF the value is 0 THEN change it to 1, ELSE do nothing
(i.e.
retain the original cell value).

Thoughts...

TIA