select column (with blanks to fill) based on cell from other column

[excel01noob]

Hello

I have a table with several columns.
The main one is column N where I want to take action as it is filled with "net amounts" but in text, plus not all the cells are filled, some have blanks, some others have zero also in text format.

I wanted to use column A "ref ID" to identify last row non-blank in that column which would define the last row in column "net amounts".
I want then to convert the numbers in text format into numbers with 2 decimals plus adding zeros in blank cells (what action should I take first here?)

I managed to do this

Dim LastRow as Long
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
Range("N" & LastRow).Select


but now how to select the column N going up until cell 2 (i am using headers) with the above criteria also included?

 

[DanteAmor]

Try this

Sub Select_Column()
  Dim rng As Range, c As Range
  Set rng = Range("N1:N" & Range("A" & Rows.Count).End(3).Row)
  rng.NumberFormat = "#,##0.00"
  For Each c In rng
    If IsNumeric(c.Value) Then
      c.Value = c.Value * 1
    ElseIf c.Value = "" Then
      c.Value = 0
    End If
  Next
End Sub