Hi Anne,
When I went back into the spreadsheet, I just chose one of the date formats
that were already there, and it showed 04-Mar-05....it was probably me that
assumed that the formatting in the code was dd-mon-yy.
I've gone back into it and used "custom" and put in dd-mmm-yy.
--
Thanks,
Diane
"Anne Troy" wrote:
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