Add apostrophe to a number with leading zero's - but keep leading zero's

[mrwul62]

Within a range (column, containing both text and numbers) I have numbers displayed like:
0001
0010
etc.

Cell properties -> custom show: 0000

I would like to add an apostrophe to those cells.
However .. the result should still be that the leading zero's are displayed, i.e. the result would be as if I were to manually enter '0001

Is there a macro that can do this?

Thanks!

 

[Peter_SSs]

Thanks again!
Really super.

No problem.