XlSortDataOption Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Specifies how to sort text.

Name

Value

Description

xlSortNormal

0

default. Sorts numeric and text data separately.

xlSortTextAsNumbers

1

Treat text as numeric data for the sort.

Show: