Remove Front Apostrophe (Text & Numbers)

Hi All

I created a simple code to remove the front apostrophe

Please Login or Register  to view this content.

It's been a while, thanks porucha vevrku for your code, works good, but only on numbers. My goal is to have an easy code to do both and must keep the format of the cell. Mine works on both but removes the formats. I also know now why mine clears all the format because I uses .clear in mine. I am busy working on something and will post in due course