how to replace 100 with zero

[kuntalnr]

Hello everyone
my dataset consist of numbers from 1-100. I want to replace all the 100s with zero. Kindly guide me through it. thank you

[Søren Larsen]

How about the search and replace function?

Select your range -> Ctrl+F -> Search for 100 - > Replace with 0 (use replace all)