Notifications
Clear all
Topic starter
I am having trouble Sorting Data that looks like this:
F-1-052917
F-10-052917
etc. When I Sort the data it always places the F-10-052917 first. My list is long and others are out of place as well. Can anyone tell me how to order my list sot the numbers dictate the order of the list?
Posted : 25/04/2017 4:12 pm
Hi Holly
You will need to pad the number with leading zero(s).
Example
F-01-052917
F-10-052917
Sunny
Posted : 25/04/2017 8:37 pm