Sorting Paragraph number convention

Giganews Newsgroups
Subject: Sorting Paragraph number convention
Posted by:  2GWLAN
Date: Thu, 10 Jul 2008

Excel 2007-
Column 1 is a building # i.e. 105 there are xx rows before the next building
number sequence.

Column 2 is CLIN... should be in the following convention-
1
1.1
1.2.1
2
2.1 Etc...

but instead it is like this
1.3.6
1.3.7
1.4.24
1.4.8
15-1
15-2
15-29
15-3
15-4
15-5
15-6
15-7
2.1.11

Originally this was an access database, but I extracted it because I didn't
like the way the report works...

Thanks,

Phil

Replies