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!
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!