sort text numbers ascending

[rjmdc]

hi
thousands of check numbers and direct deposits and quickbooks
i mergedall the various statements together via PQ
since they are not all numbers some say DD or QB i turned check number column into text
problem happens when i sort
i get 1, 100, 1000, 10000 then the 2's
this makes it impossible to find any checks
is there a way to "fool" the text and have it sort as a number?

 

[aRandomHelper]

can i add this to a macroupon activating the sheet?

Probably, you can try recording the sort process into a macro, then try to adapt the recorded macro into any code you have for the sheet activate event.

 

[Pcubed]