I am working in AV2007 and have an issue with a report we have created. IT is a cable schedule and the first column is CS_Name. These values are of the type a101 and a1012. However we have used the auto numbering tool to set the attribute using a prefix of a, then the autonumber text. This means that they come into excel in two parts. How do I do a sort on these values so that I have a nice report, ordered by CS_NAME


Many thanks, Dom

Dominic Rozendaal

_{Design & Production Resources Ltd.}