Date format in Excel

  • Thread starter Thread starter Abid
  • Start date Start date
A

Abid

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
Format>cell and from Control pannel regioanl sitting, but the problem
still exists.

thanks
 
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
 
Back
Top