Likely because it should be dd-mmm-yy, not dd-mon-yy.
************
Anne Troy
www.OfficeArticles.com

"DianeMcP" wrote in message
...
I've set the date format within the cells to appear as dd-mon-yy
(12-Oct-05)....Doesn't excel automatically change an entry entered as Oct
12
2005 to 12-Oct-05?

If it is supposed to do that, why are my cells not automatically
reformatting to the syntax I want?
--
Thanks,
Diane