Sorting Decimals as Numbers
I have a spreadsheet that has a unique identifier field containing eight
digit numbers separated by decimals. Each subset references a specific field
on another sheet. I would like to sort by this identifier, but when I do, my
decimals sort improperly (for my current need). They sort in the following
order:
1.1.1.1.1.1.1.1
1.1.1.1.1.1.1.10
1.1.1.1.1.1.1.2
I would like them to sort numerically by the last number. Is there a way to
do this, or an easier way to format this field? Thanks for the help.
|