[AccessD] Sorting Alpha-Numerics

Mark, I just tried it Excel also, if u want t do it there, make sure you
format into text first (from general)

> Mark,
>
> I believe that Excel converts 7E9 to 7 * 10 to the 9th power.
>
> Try putting a single apostrophe in front of the AAA.  In the formula bar
> it will look like 'AAA, but in the cell it will look like AAA.  This
> tells Excel that you want the cell contents treated like text, and
> should prevent the conversion to an exponential value.
>
> Dan Waters
> Quality Process Solutions
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mitsules,
> Mark Sent: Tuesday, October 21, 2003 8:59 AM
> To: '[AccessD]'
> Subject: [AccessD] Sorting Alpha-Numerics
>
>
> Greetings,
>
> I have a text field containing all possible 3 digit alpha-numeric
> combinations from 000 to ZZZ.  I am looking for a method to sort this
> text field where 000 through 999 are listed in numerical order before
> the remaining alpha-numeric combinations are listed in ASCII sort order.
>  Any suggestions?  I have tried to do this in Excel, however, Excel
> makes some startling decisions on its own...such as turning 7E9 into
> 7000000000.
>
> Example:
> 000
> 001
> .
> .
> 998
> 999
> 00A
> 00B
> .
> .
> ZZZ
>
>
> Mark Mitsules
> Senior Designer
> Department E13
> Submarine Electrical Engineering
> Northrop Grumman Newport News
> 757.380.3376
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail