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

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: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://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: http://www.excelforum.com/member.php...o&userid=31550
View this thread: http://www.excelforum.com/showthread...hreadid=512663

Do you set your date in VBA? If so, try casting it, CDate(Date).

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Steve1154" wrote
in message ...

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:
http://www.excelforum.com/member.php...o&userid=31550
View this thread: http://www.excelforum.com/showthread...hreadid=512663

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

Dim MyDate, MyShortDate
MyDate = "15 February, 2006"
MyShortDate = CDate(MyDate)

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

Steve


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

This just gets rejected

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

Steve


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