Forum

Notifications
Clear all

Sort Data with a letter first

2 Posts
2 Users
0 Reactions
110 Views
(@hollystonitsch)
Posts: 1
New Member
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
(@sunnykow)
Posts: 1417
Noble Member
 

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
Share: