In the UK we mostly record dates in dd/mm/yy format, which places the day and month numbers the opposite way round to the American convention.
Amazingly Excel 2000 doesn't offer dd/mm/yy as a date format option!
I have, in the past, managed to add dd/mm/yy to the custom format options, so it is available to me every time I open a new workbook - albeit from the illogical 'Custom' list, as opposed to the 'Date' format menu which would be much more logical.
I am now trying to set up this format on 2 colleagues workstations, so that every time they open one of my workbooks, they aren't greeted with a cell full of stars in place of the date where ever I've set up a dd/mm/yy date format field - as their copy of Excel fails to recognise my dd/mm/yy and instead tries to display dd/mm/yyyy, which of course doesn't fit!
The problem is I can't for the life of me remember how I did it. I can easily see how to create dd/mm/yy by editing a default Custom format, but what I can't seem to do is make it so that format is always available to my colleagues every time they open Excel, just as it is for me.
Thanks in anticipation