Excel Auto Formating Question

[Learning123]

Hi Everyone,
I was wondering if it's possible to turn excels auto date conversion off? For example when I text-to-column the following: 9-10-1999 Excel automaticly turns it into 9/10/99. As always thanks a lot for the help!

 

[Sopman]

I don't know of a way to turn it off, but you can put a single quotation mark ' in front.

If it is a date you can customize the cell(s) to: m-dd-yyyy

Sopman

 

[BrainB]

You can also format the column as text before you do Text to Columns. Regards
BrianB
** Let us know if you get something that works !
================================

 

[Learning123]

Thanks a lot for the help everyone, both method works, now I just need to find a way to code it. Thanks again!