delete " ' " from the sheet.

A

Arain

I am having issues deleting a ' sign from the DATE column in my sheet. Ctrl H
does not recognize the symbol and does not delete. Any ideas what of working
around it?
 
E

Elkar

Try this:

Enter a 1 into any blank cell
Copy that cell
Select your cells containing the ' to replace
From the Edit Menu select "Paste Special"
Check the "Multiply" option
Click OK
Delete the 1 you entered orignially
Apply an appropriate date format to your cells

That should do it.

Basically, the ' symbol tells Excel to override any cell formatting and
force it as text. By multiplying all cells by 1, we convert this text to a
number, and eliminate the ' from the cells.

HTH,
Elkar
 
Top