How does Excel change numbers in text format to numeric format in bulk?

How does Excel change numbers in text format to numeric format in bulk?

Steps

In Wps/excel, an area that explicitly needs to be changed from a text format to a numeric format

Enter a value of "1" in either blank position

Select "1" and then "CTRL + C"

Select the area you want to change from text format to numeric format

Click the right mouse button to select "Paste Selective"

Select all, multiply in the new window

Choose "Multiply"!

Choose "Multiply"!

Choose "Multiply"!

The destination range changes from text format to numeric format

Attention matters

Do not right-click to select Copy after 1 is selected. Be sure to "CTRL + C"

How to really learn PS

Getting Started with Photoshop learning