Replace cell with "0" value

[zaidan]

dear all,
I want to replace the cells that contain only 0 with 5000 and the keep the other cell that have 0 (i.e 6000, 7000), example :
Data :
6000
7000
0
9000
0

The result i want : (just replace the cell A3 and A5)
6000
7000
5000
9000
5000

Thank for any help

 

[Rick Rothstein]

Use Excel's Replace function. I'm not sure what version of Excel you are using, so I'll just give you the keyboard shortcut... select your column of values and then press CTRL+H to bring up the Replace dialog box. Type 0 in the "Find what" field and 5000 in the "Replace with" field, then click the "Options>>" button to reveal all the available options (assuming they are not already displayed) and make sure the "Match entire cell contents" checkbox is checked, then click the "Replace All" button.

 

[anandvarma]

Dear Rick Rothstein,

Today i learn a new trick in Excel, thanks for this answer

 

[zaidan]

Thank you Rick for your trick..