Hello,
I'm hoping there is a quick fix to this only sorting by the first digit of the number
Sorting column BB
Works when using solely numbers but my columns looks like the below and ranks only the first digit (e.g. putting 15 & 12 below 2).
How can this sorting accommodate for the full number?
Thanks for any help with this.
I'm hoping there is a quick fix to this only sorting by the first digit of the number
Sorting column BB
VBA Code:
Sub DashTop_Descending()
Range("BB1:BB200").Sort _
Key1:=Range("BB1"), Order1:=xlDescending
End Sub
Works when using solely numbers but my columns looks like the below and ranks only the first digit (e.g. putting 15 & 12 below 2).
How can this sorting accommodate for the full number?
Thanks for any help with this.