Remove apostrophe

[Adrae]

Is there a away to write a macro that will remove the apostrophe in all selected cells. I currently have dates with apostrophes in front so that they will be seen as text. I need them as dates now and find replace doesn't seem to be working.

Any ideas? Thanks

 

[Dave Hawley]

I think the user wanted a macro to do this, which is why I suggested.

Sub DoIt()
Selection = Selection.Value
End Sub

 

[Tommy Bak]

Sorry Dawe.
I didn't read the question correct.
Your solution is simple, short and beutyful.
regards Tommy

 

[pchelpsource]

Hi
Just a follow up on Yogi's answer.
Put 1 in random cell.
Choose copy
Mark your Date-cells
Choose paste special
Choose Multiply
All of your dates are now multiplied by one and converted to values.
Format them to dates

regards Tommy

sorry to bump such an old thread, but I just wanted to say thanks for this simple solution. you made me a hero for 5 minutes today!

 

[SureshNaiduA]

Select an empty Cell

And copy it

Now select the cell(s) which you have apostrophe before the date.

Make a right click and select Paste Special

Then select the formats button in the options window opened

and press Ok

It solves you problem

If not please mail to sureshnaidu143@gmail.com