Convert text to numbers into multiple columns

[neeraj2050]

Greetings!!

How to convert "texts to numbers" into more than one column at once.

I can do it column wise one by one. But if there are multiple columns then how same could be addressed

Regards
Neeraj Kumar Agarwal

 

[Hui]

If you are simply converting cells that look like numbers but are Text
in a Blank cell type 1
then select and copy that cell
Select the whole range with the numbers
Goto Home, Paste, Paste Special,
Select Values, Select Multiply
Apply

 

[neeraj2050]

Sir, I understand this. But my data is into different column which are scattered into different columns.

 

[Hui]

You can select whole columns doing this technique

Would you like a VBA solution?

Refer to a number of solutions here:
http://www.contextures.com/xlDataEntry03.html

 

[neeraj2050]

Sir, still wondering how to get this done into entire columns at once

 

[Hui]

in a Blank cell type 1
Then copy that cell
Select the whole Column/s with the numbers
Goto Home, Paste, Paste Special,
Select Values, Select Multiply
Apply

To select a Column click on the A, B C etc above the Column
Hold Ctrl and Click on other columns to add multiple other columns

 

[neeraj2050]

Thank you very much!!