Home

How to get rid of quotations between numbers

ccjaime
Occasional Visitor

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.

Related Conversations
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Adding Display Zero as Dashes to Custom Excel Number Format
emmagreen in Excel on
1 Replies
Arabic numbers in OWA 15 with SharePoint 16
Deleted in SharePoint on
6 Replies