I posted this in the apple support forums, but thought i'd try here as well.
I have a spread sheet that tracks changes in various versions of a program. Because of the way software is assigned version numbers i'm having a hard time finding a cell format that will:
a) sort by version number correctly, and b) only add a trailing zero after a decimal point if it is explicitly typed.
For example the numbers should sort in the following manner:
1.1
1.2
1.10
1.12
1.20
1.22
The standard number format will sort properly, if I go in by hand and edit the number of decimal places, but with around 200 entries I'd like to avoid that. I'm sure I'm not the first person to have this problem, has anyone found a way to make it work?
Edit:
I've come fairly close, these rules seem to work the majority of the time, any have any better ideas?
I have a spread sheet that tracks changes in various versions of a program. Because of the way software is assigned version numbers i'm having a hard time finding a cell format that will:
a) sort by version number correctly, and b) only add a trailing zero after a decimal point if it is explicitly typed.
For example the numbers should sort in the following manner:
1.1
1.2
1.10
1.12
1.20
1.22
The standard number format will sort properly, if I go in by hand and edit the number of decimal places, but with around 200 entries I'd like to avoid that. I'm sure I'm not the first person to have this problem, has anyone found a way to make it work?
Edit:
I've come fairly close, these rules seem to work the majority of the time, any have any better ideas?
