Method 1: Find and Replace Method (Failed!) Next, let’s try the Find and Replace function to see if we can remove the leading single quotes at once. Press Ctrl+H to bring up the Find and Swap dialog box, and enter a Half-width single quotation mark, "Replace with" means leaving it blank, click "Replace All", but the result is not found at all!

Method 2: Operation pasting method (success!)

The first step is to select any blank cell in the worksheet, enter "0" in it, then right-click the cell and select "Copy".

In the second step, select all the cell ranges to be converted, right-click the mouse, select "Paste Special" in the right-click shortcut menu, and select "Add" in the "Operation" area of ​​the pop-up "Paste Special" dialog box. , click the "OK" button to end. Finally, delete the "0" we entered in the blank cell.

Method Three: Quick Menu Method (Quick!)

In addition, there is a faster method: select all the areas to be converted, a floating button with an exclamation mark will appear to the left of the first cell in this area, click the drop-down menu to the right of the exclamation mark, and select "Convert to numbers" completes the work of removing the half-width quotation marks and converting the format to numbers.