If you add a hidden apostrophe, you are converting the number to text, if
this is what is intended.
Asap utilities it has the function 'convert number to text', in the number
selection.
http://www.asap-utilities.com/
"hedgracer" wrote in message
...
I need to use a function to add a hidden apostrophe to a cell. For
example, the cell has 2021 and needs to have '2021 with the ' hidden.
Does anyone know a function that can do that? Any help is appreciated.
Thanks.
Dave