[AccessD] Sorting Alpha-Numerics

The problem with using Excel is getting it in there in the first place.
Excel apparently knows better than I what I want:(  On pasting as Text, it
automatically does the conversion back to numeric.  With 46,655 records I
would prefer not to do any manual editing such as formatting with a " ' " or
changing entries like 7000000000 back to 7E9.  The Access table I have has
all the data already in the correct format...I was hoping for an SQL sorting
solution.  I'm just frustrated with my lack of vision on this particular
problem.



Mark


-----Original Message-----
From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] 
Sent: Tuesday, October 21, 2003 10:40 AM
To: accessd at databaseadvisors.com
Subject: RE: [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


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com