sorting alphanumeric characters

J

jan

I use macros to insert terms and their abbreviations in a document that consists wholly of one two-column table. After I add a new pair, I want the table sorted alphanumerically in ascending sortorder. It works fine, but something weird happens when I insert the numerical '1' as abbreviation for 'one'. The first time that I sort the new pair will end up in the first row of the table. However if I sort the table a second time, the pair ends up in the last row, and vice versa

Every time I sort the table this one pair swaps from first to last row and back

Is there something I do wrong, something I leave out
I hope some one knows an answer

Thank you
Jan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
Sorting problem. My header rom is getting sorted with the rest. 1
Sort range in table 2
SORTING HELP! 2
First FieldNumber ignored when sorting table 1
Excel suddenly crippled by Just-In-Time Debugging 2
Sorting a Worksheet by the first 14 characters in Column A 1
Random table of data - need to find every cell that contains specific data 1

Top