Hi Josh7,

Format the date entry cells with a custom format:

dd-mmm-yyyy

---
Regards,
Norman



"josh7" wrote in message
...
When I enter a date value in excel spreadsheet like 01-Jun-2005 ,its
saving
the value as 01-Jun-05 instead of 01-Jun-2005.What should I do to save it
as
01-Jun-2005.
Thanks,
Joshua