Dan Waters
dwaters at usinternet.com
Tue Oct 21 09:22:25 CDT 2003
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