How do I convert cells filled with character numbers to numeric values so I can use the values in Excel math formulas.

Question

How can I insert the content of excel file into MySQL Table, any pointer?

Answer 1

Step 1: Select the cells that contain the numbers that are stored as text.
Step 2: On the Home tab, in the Number group, click the Dialog Box Launcher Button image next to Number.

Step 3: In the Category box, click the number format that you want to use.

And you are done...