VBA - Convert to Number (Range)

[ExcelMercy]

Hey Everyone,


I'm wanting to avoid constantly having to "Convert to Number" on one of my sheets.

[TABLE="width: 500"]
<tbody>[TR]
[TD]

[/TD]
[TD]<- I don't want to have to do that.[/TD]
[/TR]
</tbody>[/TABLE]



I also don't want a function like =A1*1 in another column.


I would like a macro that I click once to "Convert to Number" all of Column A:C.



Any assistance would be greatly appreciated! :D

 

[Jonmo1]

You can do them all at once with
Data - Text To Columns - Deliminated - Finish

 

[ExcelMercy]

Awessssssssome, Thanks!

 

[Jonmo1]

You're welcome.