Hi Marco
Format the cell as Text to get it to appear as 1/1.
But it may 'cause you some grief if you want to do any calculations.
Maybe if you gave us some idea on what you were trying to achieve, we could
provide a better solution.

HTH
Michael

"marco" wrote:

I enter 1/1 and get 1/1/2005, I can manually add a space but this is
imported data so it comes in as 1/1, no matter how I format the cell I still
end up with 1/1/2005. I have turned off all auto complete and auto correction
selections. I also get the same results no matter what cell I enter 1/1.

Marc