Need to find end row in Col which has data & format the col

[Closed]
Report
Posts
1
Registration date
Monday August 10, 2015
Status
Member
Last seen
August 10, 2015
-
Need to check when the row is finished - by checking whether data is there in the cell or not and format entire column.
Example Col A.. has data upto row 2100 , then select all rows and format it to number.

the data will be copied into Excel Col A everytime... so the rows won't be same everytime..

Need to write VBA script (Macro)