Expand Minimize

XlSortDataOption Enumeration

Specifies how to sort text.

Version Added: Excel 2007

Name

Value

Description

xlSortNormal

0

default. Sorts numeric and text data separately.

xlSortTextAsNumbers

1

Treat text as numeric data for the sort.

Show:
© 2015 Microsoft