REmoval of Date formula in excel

[durairetnam]

hi guys ,

Could you please help me to solve the problem in excel.

I have seen some advice says that to remove the date formula , we have to mark ' before the dates.some less entry we can do it by cell by cell, where as I have lot of entries ( nearly 15000) , its very difficult for me to mark, is there any short cut ,where I can mark the ' to all the entry at a time .


42039 04/02/2015
42039 04/02/2015
42039 04/02/2015
42039 04/02/2015
42039 04/02/2015
42039 04/02/2015
42040 05/02/2015
42040 05/02/2015
42040 05/02/2015
42040 05/02/2015
42042 07/02/2015
42042 07/02/2015
42042 07/02/2015
42042 07/02/2015
42042 07/02/2015

[LokeshKumar]

I just want to know the output from your end for the requested query......

[ashishmehra2010]

Hi,

Welcome to the forum!
Kindly follow the below steps:

Select the range >
Press F2 >
Manually enter apostrophe in front >
Press CTRL + ENTER keys

Regards,
AM