Thread: getting the number format of a column

Hi Chris, welcome to the forum.

Cells have number formats, columns do not. You can loop through each cell in the column or a range and determine the NumberFormat property, though.

Code:

Sub numFmt()
Dim ce as Range
For each ce in Range("E1:E10")
    MsgBox ce.NumberFormat
Next ce
End Sub

Any cell formatted as Text will return: @

Hope that helps!