Hi everyone, I normally use excel 2000, and created a database with all dates in it. The database is accessible on the network, but some computers use MS Excel 2003. This seems to be causing a problem with the dates. I changed the cell format to dd-mmm-yyyy so when you type 3/4/85, it should show up 3-Apr-1985, but in 2003, it changes to 4-Mar-1985. The weird thing is, in the formula bar, it shows as 3/4/85. It's as if it converts the dates into American, but I'd like it to show up as 3-Apr-1985. Is there a setting in options doing this??

Thanks,
Andrew