Sort value list

[Brandon HanYee]

Hi,

I am finding the solution for sort value list.

Example:

Current value list:

A 1

A 10

A 11

A 2

A 21

A 3

A 4

 

I want the value list look like this:

A 1

A 2

A 3

A 4

A 10

A 11

A 21

P/s: I need to use the data field = Text.

Anyone can help me? Thank you.

[Lee Smith]

Text doesn’t sort like that. Depending on how much your list could grow, increase the lead zeros.

For your needs up to 100, Use A01, A02 - A99

If it will be larger, use more lead zeros. 

hundreds

A001, A002, - A100

thousands.

A0001, A0002, - A1000

[Brandon HanYee]

Thanks Lee..