How to get rid of quotations between numbers

Copper Contributor

How can I get rid of or clear of equal sign and quotations between numbers in a cell or range of cells.

 

Thank you,

="""123456"""

 

1 Reply

If Ctrl+H on you range and Replace All quotation marks on nothing you will convert your texts to numbers. Equal sign affects nothing, not necessary to remove it. But you may Ctrl+H on it as well.