Hi LS,
As Dave said, it depends on whether your ids carry characters. If they are
all numbers, then another alternative is to create a new column using Value
function. For example, if column A contains the original ids: A1 = 00085, in
the new column B, B1, set the function =value(A1) will return 85 as a number.
Then sort column B instead of column A.
Anki
"l smith" wrote:
I am having trouble sorting a column of id numbers because some of them
contain leading zeroes. Excel doesn't recognize that no matter how I format
the cells. Help!
LS
|