adding a hidden apostrophe to a cell

[hedgracer]

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

 

[FSt1]

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

 

[Barbara Wiseman]

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/

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk