[Vortex]

I have a text custom column in Calibre that has text followed by zero to three digits at the end. ie.

texta 1
texta 9
texta 12
textb 1
textb 2
textc 15
textc 37

How do I get the column to arrange numerically without having to add whole strings of zeros to the front of every digit or have the digits surrounded by []?

Thanks