Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting column as text.
i have data in a column that looks like this - mar06-may07. i want to use
"text to column' and separate the two dates. i have formatted both columns as text so it won't 'interpret' Mar06 as 3-Mar or may07 as 7-may. BUT it won't stop formatting the data as 6-Mar or 7-may. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) | |||
column to column conditional formatting won't work, need formula | Excel Worksheet Functions | |||
Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) |