I have a list that breaks down periods within our accounting calendar. P1, P2, P3,...P12. The problem I am having is when I perform a lookup on this column it's sorting by alphabetical order and it puts it in this order: P1, P10, P11, P12, P2, P3, etc. This column is a string column type so i can't sort numerically. I'm not a developer so coding would be lost on me.
Any ideas on how to fix without programming so it doesn't sort that way? Thanks!!!