Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retain Numbers as Text Format When Importing. | Excel Discussion (Misc queries) | |||
converting text to negative numbers! | Excel Worksheet Functions | |||
How to reformat numbers stored as text (apostrophe at beginning) | Excel Discussion (Misc queries) | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions |