I have a textbox on a userform in which the date is entered, in dd/mm/yy
format.

When it is shown in a cell in the spreadsheet, it shows as mm/dd/yy.

Is there anyway of getting it to appear in the cell as typed?

I have tried to change the formatting but this does not work.


--
ingleg
------------------------------------------------------------------------
ingleg's Profile: http://www.excelforum.com/member.php...o&userid=33037
View this thread: http://www.excelforum.com/showthread...hreadid=558819

When a user types 01/02/03, do they mean Jan 2, 2003 or Feb 1, 2003 or....

Entering dates in an ambiguous format can sometimes result in the wrong dates.

You may want to drop the textbox and use a calendar control:

Ron de Bruin has some tips/links at:
http://www.rondebruin.nl/calendar.htm


Or use three different controls (one for the month, day and year) to get the
date.

ingleg wrote:

I have a textbox on a userform in which the date is entered, in dd/mm/yy
format.

When it is shown in a cell in the spreadsheet, it shows as mm/dd/yy.

Is there anyway of getting it to appear in the cell as typed?

I have tried to change the formatting but this does not work.

--
ingleg
------------------------------------------------------------------------
ingleg's Profile: http://www.excelforum.com/member.php...o&userid=33037
View this thread: http://www.excelforum.com/showthread...hreadid=558819

--

Dave Peterson