Did you specify Text in Step 3 of that dialog for each field?

ellen wrote:

MAR06 is March, 2006. Excel doesn't want to format the columns to text. I
am using the format-cells-text option.

"Dave Peterson" wrote:

How about telling excel that both of the columns should be Text when you're
going through that data|text to columns dialog.

(Don't use General)

If you want to change the strings to real dates later, you'll want to post
back.

Is Mar06=March 1, 2006 or March 6, 2007?



ellen wrote:

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.

--

Dave Peterson


--

Dave Peterson