Simple macro needed to format and update a column of values

Hi,

I've never written an Excel macro before, so I'm a little confused as to how I would begin with this.

The task seems pretty simple. I need to iterate through a column of values.

For each value:
* Format as text
* If the value contains an apostrophe as its first character, remove the apostrophe

Thank you for your help!