software

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: www.excelforum.com/member.php...oamp;userid=31550
View this thread: www.excelforum.com/showthread...hreadid=512663
Have you tried setting a custom format of an English date dd/mm/yy, We
have the same problem, But sheets formated form the custom tab do
retain the same format when we reopen them. i guess its probably down
to network settngs tho

regards

Dav--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=512663
I need something like
Sub UserForm_Initialize()
onopen longdate.format=dd/MM/yy

in the initialising sequence but I have tried this so many ways my
heads spinning

Steve--
Steve1154
------------------------------------------------------------------------
Steve1154's Profile: www.excelforum.com/member.php...oamp;userid=31550
View this thread: www.excelforum.com/showthread...hreadid=512663Do you set your date in VBA? If so, try casting it, CDate(Date).

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Steve1154quot; gt; wrote
in message ...
gt;
gt; I need something like
gt; Sub UserForm_Initialize()
gt; onopen longdate.format=dd/MM/yy
gt;
gt; in the initialising sequence but I have tried this so many ways my
gt; heads spinning
gt;
gt; Steve
gt;
gt;
gt; --
gt; Steve1154
gt; ------------------------------------------------------------------------
gt; Steve1154's Profile:
www.excelforum.com/member.php...oamp;userid=31550
gt; View this thread: www.excelforum.com/showthread...hreadid=512663
gt;

Hi
Thanks for the idea, I've never heard of this befor. I just tried

Dim MyDate, MyShortDate
MyDate = quot;15 February, 2006quot;
MyShortDate = CDate(MyDate)

It accepts the code (thats good) but it has no effect

Steve--
Steve1154
------------------------------------------------------------------------
Steve1154's Profile: www.excelforum.com/member.php...oamp;userid=31550
View this thread: www.excelforum.com/showthread...hreadid=512663
This just gets rejected

Dim MyDate, MyLongDate
MyDate = quot;15 February, 2006quot;
MyLongDate = CDate(dd / MM / yy)

Steve--
Steve1154
------------------------------------------------------------------------
Steve1154's Profile: www.excelforum.com/member.php...oamp;userid=31550
View this thread: www.excelforum.com/showthread...hreadid=512663