LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default Sorting numbers as Text

I frequently work with a lists of text data, some of which consists of digits
or digits + alpha characters. These are always formatted as tect fields.
When I sort them i get a dialog box asking if I would rather sort digits as
numbers or as text. Sorting as text provides the result I need, so I always
select that and it works fine
My question is, how can I skip having to answer this question over and over
and over? Is there a configuration option thats says 'leave me alone - I know
what I am doing' ?

Thanks for any help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Retain Numbers as Text Format When Importing. xardoz Excel Discussion (Misc queries) 2 June 20th 06 05:16 PM
converting text to negative numbers! via135 Excel Worksheet Functions 6 February 5th 06 06:29 AM
How to reformat numbers stored as text (apostrophe at beginning) Dave Excel Discussion (Misc queries) 1 May 11th 05 02:34 AM
How to convert Excel imported numbers from text to numbers? Alden Excel Discussion (Misc queries) 9 April 1st 05 09:51 PM
Sort or Filter option? Mcobra41 Excel Worksheet Functions 3 February 23rd 05 07:22 PM


All times are GMT +1. The time now is 11:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"