How do I fix my custom index order?

[jcc5018]

I am trying to include a bible verse index that is organized by biblical book order.  I finally figured out that I could do this similar to WORD by adding a numerical field in the sort by entry of "Edit topic" 

so Genesis would be 01, Revelation 66  and so forth. This works fine, though took forever to manually update over a hundred records, especially since it was already done once in WORD. 

But the problem comes when I reach  the psalms that have 3 digit chapter numbers. So what would be 1910305 for example (ps 103:5) ends up at the end of my index instead of after anything before PS 99.  I thought that adding the psalm entries with 3 digits so PS 99:1 would be 1909901  for example, would help, but that sent all the psalm entries to the end since the resulting  value is larger than every other book.  

So short of going through all 100+ entries and adding an extra leading 0 to all chapter numbers, I'm not sure the quickest way to fix this. 

some programs sort number lists like 4,40,400,5,54,543... while others sort as they should be without needing leading 0's. (4,5,40,54,400,543)   It appears affinity may be sorting the latter method, but it creates the challenge mentioned above.   Is there a better way to sort by Bible book order? And if so, is there a faster way to clear or alter the sort by list than the 3-4 clicks it takes with current method? 

[walt.farrell]

I think it's a straight alpha sort, which means adding the extra 0s may be your only workable approach.