To sort correctly, all entries in a sort field must have the same number of
digits, so your "4" would have to appear as "04". You can do this with the
Format-Cells Number tab. Select the "Custom" function and in the right-hand
box enter 00, 000, or whatever will be the maximum number of feet in your
sort. This will place 04 before 11.

Sorting by feet and inches is more difficult. Try the Convert function.

"rbashley" wrote in message
...
How can I insert measurements in feet and inches and still be able to use
"sum" and "sort" options? I can insert them so that I know what they
mean,
but "sort" thinks that 11" is smaller than 4".