I would like to know how I can change a number to another automatically.

I bring data into excel from another source. All the zeros which come
across I want to populate with 0.5 . I want to apply this formula to my
template so it is done automatically and I don't have to use the find and
replace function.

Thanks

Caroline