Question

4. How number enter as text can be converted into number again?​

Answer 1

Answer:

To do this:

Select the cell (or cells) containing the values that you want to convert. This will cause a warning symbol to pop up at the side of the cell(s). ...

Click on the warning symbol, to bring up the Error Checking menu (see above). Select the Convert to Number option to convert the cell values into numbers.

Explanation:

hope this answer help u

Answer 2

Explanation:

4. How number enter as text can be converted into number again?

• Highlight the range of text to be converted.
• Go to Data, Text to Columns.
• Click Finish. The numbers are no longer considered numbers stored as text.