I have a problem that's causing much frustration:

- I set my OS' regional settings to English (US) but changed the short date format to the more sensible dd/mm/yyyy

- I have columns in Excel that are formatted dd/mm/yy

- When I use Cells(1, 3).Value = "01/02/03" where C is one such column, "02/01/03" appears!

Why is Excel changing this? Why does it think I would use .Value = and specify the incorrect format. How can I solve this problem?

Thanks
-jt