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

hi
if you only have one then you can use the find and replace to do that
Ctrl+F replace tab
Replace what: 2021
Replace with: '2021
click replace button

if you have a lot, then you would be looking a macro.

Regards
FSt1

"hedgracer" wrote:

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

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

Select the range with the cells that you want to change then run this Macro:

Sub AddIt()
For Each cell In Selection
cell.Value = "'" & cell.Value
Next cell
End Sub

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"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