PC Review


Reply
Thread Tools Rate Thread

Date format in Excel

 
 
Abid
Guest
Posts: n/a
 
      28th Mar 2007
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

 
Reply With Quote
 
 
 
 
Incidental
Guest
Posts: n/a
 
      28th Mar 2007
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

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting complex date format to normal date format in Excel BlackNarcissus Microsoft Excel Misc 0 28th Jul 2011 04:28 PM
Convert date (m/dd/yyyy) in text format into an excel recognised date Rob P Microsoft Excel Programming 3 30th Apr 2010 12:40 AM
Excel format in selected cells have changed to DATE format!!!! mybigspamemailaccount@gmail.com Microsoft Excel Discussion 2 4th Feb 2010 03:24 PM
Format an Excel Column in the window's short date format. jim kane Microsoft Excel Programming 7 25th Jan 2007 02:41 AM
Excel 2000 date format cannot be set to Australian date format =?Utf-8?B?QnJpYW4gSm9uZXM=?= Microsoft Excel Misc 1 30th Mar 2005 06:03 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:15 PM.