Thank you, The macro works and I can sort numbers as text




?B?RWR3aW4gVGFtIChNUyBNVlAp?= wrote in
:

I think the only way is to add the "'" character at the front of the
numeric values to force Excel to think of them as text.

To quickly process all cells and add the prefix character, you may use
the following macro. First select the range of cells which contains
the numbers and then run the macro.