Hi
I use a form that pulls in a range of dates from excel. I need date to
be in 28/2/06 type format. Only trouble is every time I shut and reopen
the workbook the date comes in as 02/28/06.
To solve this I am currently having to go through control panel,
regional settings,customise,date,and highlighting the longdate format
dd:MM:yy (Which is already showing as active option)
How can I force excel to use this format automatically?

Nb the dates on the spreadsheet are already formatted to 28/02/06

This one has been causing me a headache for over 2 year now - I just
discovered this forum so really hope someone knows the answer
Cheers
Steve


--
Steve1154
------------------------------------------------------------------------
Steve1154's Profile: http://www.excelforum.com/member.php...o&userid=31550
View this thread: http://www.excelforum.com/showthread...hreadid=512663