Select range base on another Column

I am trying to select column B, based on the range of column A.

Since Column B has some blanks cells. Since I treid to use this function for column B and it didn't work since the cells are blank

    Range(Selection, Selection.End(xlDown)).Select
    Range(Selection, Selection.End(xlToRight)).Select

Also once column B is selected convert the text to Numbers format