Sorting question

[Nathalie_Salas]

I have the following number format in a column:

270417-001935

I need to sort the column from low-high based on the last 6 didgets 001935. Is this possible?

Thanks,

Nathalie

[Jeremy_Oglesby]

You’ll have to make another field - perhaps call it “Sort By” - and make it a formula field with this in it:
RIGHT({name of number field}, 6)

That will pull only the last 6 digits out in the “Sort By” field, and then you can hide that field, but still use it to sort by.

[Nathalie_Salas]

Thank you Jeremy. I will give it a try.