| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
set all column formats to Text
By default, all columns are formatted as General. This screws up alphabetic
sorts: the name TRUE ends up after the Zs, the name MAY or JUNE etc. ends up as a date. Ok, so you change the format of all columns to Text, one by one. Can the default format be set to Text? Or is there an easier way to change the format of a number of columns at once? All the Excel help articles I could find worry about changing number formats, and are no help to me. Regards, Gerry Metze |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Text Wrapping | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
Threaded Mode
