That's how Excel sorts.

Numbers first then if your link formulas return "" they will appear then text.


Gord Dibben MS Excel MVP


On Thu, 3 Jul 2008 10:48:01 -0700, Jessabez
wrote:

I have a master file I am working on in which data on one tab is linked to
other tabs. I have a macro for them to be sorted, but when I sort, only the
numbers sort and then the words are bumped to the bottom of the sorting
block. I end up with numbers sorted and then a huge gap with the words sorted
at the bottom. Any suggestions to fix this?