| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text & Number Formats
When I open a new blank spreadsheet, the default format is General. I
highlight a field (A) and right click to change format to Text. If I enter numeric data in the cells, how can I sort them as if they were in the number format? The reason I ask this is because many numbers have 0 to begin with. But, sometimes I want to see them in numeric order. -- Gator |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text & Number formats for Vlookups | Excel Discussion (Misc queries) | |||
| Sumproduct with both number and text formats | Excel Worksheet Functions | |||
| Custom number formats in TEXT function | Excel Worksheet Functions | |||
| Text, Number and Date formats excel 2003 driving experienced user | Excel Discussion (Misc queries) | |||
| Can you retain different text formats when merging text? | Excel Discussion (Misc queries) | |||
Threaded Mode
