Then you must format the cells to your date entry style.

Either before or after.

BTW............Excel does not control default date format.

That is controlled by your Windows Regional and Language settings.


Gord Dibben MS Excel MVP

On Mon, 22 Mar 2010 07:51:01 -0700, Margaret L. B. <Margaret L.
wrote:

I want my dates to stay as I have typed them - not for them to be changed
for the Excel default system.