How can I replace all 1 values with a tick in an excel column

[jeep2001]

I have a column in an Excel sheet that contains a 1 or 0 value. I would love to replace the 1 with a tick or check.
The column contains 4,000 rows, so I need a programmatic way of changing the value. How can i do this in EXCEL?

 

[randy700]

On the Edit menu.... select Replace.
Fill in the appropriate boxes in the Find and Replace popup.


Randy

 

[xlhelp]

Just in case ---- checkmark is ALT+251

Member AAA - Abolish Abused Abbreviations

 

[jeep2001]

Find and Replace worked like a charm. Thank you.