Excel 2007 and date format

[picklefactory]

Hi folks
Not sure if I'm just being dumb here. (Probably), but......I have simple column of dates, I have set format to dd/mm/yy. Am I correct in thinking this should force dates entered into this format? Reason I ask is that I'm trying to create a sheet to make people keep to the correct syntax. But even with cells formatted as above, I can still enter 04.07.08 or 04.07/08 or 04/07.08 or 04.07.2008 and other variants and they remain as typed. Shouldn't the formatting sort this out and fix the syntax to the format I selected?
Thanks

 

[cummingsea]

Picklefactory you appear to be arrogant. you said the following:
I know what I mean and you should be able to read my mind.
There are no mind reader's here, and I think you should Apologize to the good people of this board who are spending there time to help idiots like us. If I was one of this talented people for what you said I would have not helped you.
sorry if I have offended you.

 

[njimack]

Cummingsea,

I don't think it was meant literally. The OP was admitting that he hadn't explained his problem as well as he would have liked.

Picklefactory you appear to be arrogant. you said the following:
I know what I mean and you should be able to read my mind.
There are no mind reader's here, and I think you should Apologize to the good people of this board who are spending there time to help idiots like us. If I was one of this talented people for what you said I would have not helped you.
sorry if I have offended you.

 

[cummingsea]

Even so if he want's a mind reader maybe he should go to a carnival, lot's of them there.

 

[picklefactory]

njimack - spot on again, your help is very much appreciated and I'm pleased you can take and understand a comment intended to poke fun at myself not at anyone else.

cummingsea you need to get out more, I'm sorry that you failed to understand that.

 

[imajio]

I am not able to get this to work. Can anyone help please?