Date format in Excel
 

hi all,

date in the excel have some problems when i wtire 14/01/2007 it
chenges sutomatically to "01/14/07. i did change it from the
Formatcell and from Control pannel regioanl sitting, but the problem
still exists.

thanks

Date format in Excel
 

Hi Abid

you could try using cdate i.e.

Private Sub CommandButton1_Click()
mydate=textbox1.value ' add 01/03/2007 to the textbox then press the
button
[A1].Value = CDate(mydate)
End Sub

for more information on cdate search excel help or this newsgroup...
the mighty tom ogilvy has a wealth of posts explaining this

hope it helps

S