Jethro
Willing to be picked up on this, but I think this picks up your short date
setting in windows regional settings. (since Y2K normally dd/mm/yyyy). You
could set it in code though using a button to hard enter the date as you
require. You could maybe use events to trigger it so it is always updated
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
